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
sim56553141s_im
skim105322511skim
slam67737971slam
slid55828981slid
slime74925751slime
slims75423651slims
slimy105417421slimy
slip67031731slip
slit46250101slit
slum65430511slum
swim96221401swim
aim57858212_aim
alif76242142alif
alit46155692alit
alum65227612alum
blam86131702blam
blimp115612942blimp
blimy125212822blimy
blin67228172blin
blip88322772blip
brim85629372brim
claim95616912claim
clam86332292clam
climb115413592climb
clime95720892clime
clip86924002clip
dim68146492_dim
elm57531742el_m
film94828172film
flam96333292flam
flic96223732flic
flip96324262flip
flir76422202flir
flit76539272flit
glam76529342glam
glia56423152glia
glib79421442glib
glime85620192glime
glims87417672glims
glom75424382glom
glum75825102glum
grim76929422grim
him86247662_him
ilia46026822ilia
ilium74614182ilium
kelim11912552kelim
kilim11711892kilim
klik74412652klik
lam57666712_lam
li29948752_li_
lib57750272_lib
lid47453522_lid
lie38264522_lie
lima65734132_lima
limb85429382_limb
lime66244932_lime
limn66527692_limn
limo65529732_limo
limp88432492_limp
limy95727712_limy
lin37967372_lin
lip514755802_lip
lis37162272_lis
lit39377312_lit
lum55542932_lum
maim85831492maim
mim76048422_mim
nim57142952_nim
olio46829672olio
oxim131114052oxim
plie65127392plie
plum85122102plum
prim85132202prim
rim56052272_rim
said55742112said
sail45447162sail
sain45551292sain
salic73424712salic
salmi7815862salmi
scam85932352scam
scrim95419742scrim
scum85924522scum
seam66645972seam
seem65438562seem
sei36048932sei_
seif75638732seif
seis45542392seis
seism75019022seism
semi65127222semi
sham96436362sham
shims104422552shims
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
si29149572s_i_
sib56850312s_ib
sic55847872s_ic
sild55030582sild
silk85529322silk
sill45545152sill
silo46037912silo
silt46558192silt
sima64730782s_ima
simp85228772s_imp
sims65737172s_ims
sin36265892s_in
sip57656012s_ip
sir35746672s_ir
sis37360542s_is
sit35877752s_it
six105339742s_ix
ski74925692ski_
skid95720932skid
skimo116312542skimo
skimp135411322skimp
skims114517192skims
skin85927532skin
skip105421752skip
skis84825292skis
skit85437532skit
slab67133762slab
slag55934352slag
slain54923572slain
slams74927902slams
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sled55334372sled
slew76228232slew
slice74925822slice
slick115520522slick
slide64725412slide
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
vim87437022_vim
whim126220532whim
ylem9217892ylem

Search took 2 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.280638182.1
2DLD Change Limit298721990.87634100.5
3Display Results1991990.0603316.7
 (SQL Overall)1786911991.216146949.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.