Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “slim” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

199 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
slim6663196(None) 
glim76026351glim
shim95827861shim
sim56553151s_im
skim105322521skim
slam67737971slam
slid55828991slid
slime74925751slime
slims75423651slims
slimy105417421slimy
slip67031731slip
slit46250101slit
slum65430511slum
swim96221401swim
aim57858222_aim
alif76242142alif
alit46155692alit
alum65227612alum
blam86131702blam
blimp115612942blimp
blimy125212822blimy
blin67228172blin
blip88322772blip
brim85629372brim
claim95616912claim
clam86332292clam
climb115413592climb
clime95720892clime
clip86924002clip
dim68146502_dim
elm57531742el_m
film94828182film
flam96333292flam
flic96223732flic
flip96324262flip
flir76422202flir
flit76539272flit
glam76529342glam
glia56423152glia
glib79421442glib
glime85620192glime
glims87417672glims
glom75424382glom
glum75825102glum
grim76929422grim
him86247672_him
ilia46026822ilia
ilium74614182ilium
kelim11912552kelim
kilim11711902kilim
klik74412662klik
lam57666712_lam
li29948762_li_
lib57750282_lib
lid47453532_lid
lie38264532_lie
lima65734142_lima
limb85429392_limb
lime66244942_lime
limn66527702_limn
limo65529742_limo
limp88432502_limp
limy95727722_limy
lin37967382_lin
lip514755812_lip
lis37162282_lis
lit39377322_lit
lum55542932_lum
maim85831492maim
mim76048432_mim
nim57142962_nim
olio46829672olio
oxim131114052oxim
plie65127392plie
plum85122102plum
prim85132202prim
rim56052282_rim
said55742122said
sail45447162sail
sain45551292sain
salic73424712salic
salmi7815862salmi
scam85932352scam
scrim95419742scrim
scum85924522scum
seam66645972seam
seem65438562seem
sei36048932sei_
seif75638732seif
seis45542392seis
seism75019022seism
semi65127222semi
sham96436362sham
shims104422552shims
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
si29149582s_i_
sib56850322s_ib
sic55847882s_ic
sild55030592sild
silk85529332silk
sill45545162sill
silo46037922silo
silt46558202silt
sima64730792s_ima
simp85228782s_imp
sims65737182s_ims
sin36265902s_in
sip57656022s_ip
sir35746682s_ir
sis37360552s_is
sit35877762s_it
six105339752s_ix
ski74925702ski_
skid95720942skid
skimo116312552skimo
skimp135411332skimp
skims114517202skims
skin85927542skin
skip105421762skip
skis84825302skis
skit85437542skit
slab67133762slab
slag55934352slag
slain54923572slain
slams74927902slams
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sled55334372sled
slew76228232slew
slice74925822slice
slick115520522slick
slide64725422slide
slier54827242slier
slily85820032slily
slimed94915122slimed
slimes84722042slimes
slimly11408902slimly
slimsy11407722slimsy
sling66028802sling
slink95422912slink
slipe75626132slipe
slips76023722slips
slipt76627482slipt
slits56128852slits
slob66029422slob
sloe45534952sloe
slog56728272slog
sloid64619712sloid
slop66533872slop
slot46049832slot
slow77729492slow
slub65428032slub
slue45332192slue
slug55124642slug
slump94816632slump
slums74623432slums
slur45525152slur
slut45040592slut
sly66228562sl_y
smit65138412smit
snib66522982snib
snip66424652snip
snit46342472snit
soil46138832soil
soli46637012soli_
solid65025082solid
solum74717612solum
som59153812s_om
spam85930042spam
spic85227432spic
spik105419712spik
spin66231302spin
spit65545082spit
spiv95917792spiv
split75729012split
sri35634002sri_
sris45434152sris
stem610628252stem
stime76521802stime
stimy105114742stimy
stir45723252stir
stum65526022stum
suit45649872suit
sum56346012s_um
swam96329982swam
swig85818022swig
swims105514142swims
swum96416822swum
syli74318982syli_
sylis84316022sylis
trim65329522trim
vim87437032_vim
whim126220532whim
ylem9217892ylem

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691298720.300595636.7
2DLD Change Limit298721991.84316208.4
3Display Results1991990.0762618.4
 (SQL Overall)1786911992.21980527.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.