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 “soil” 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.

277 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
soil4613883(None) 
boil66335181boil
coil66439651coil
foil76433911foil
moil65534091moil
noil46133241noil
oil37452051_oil
roil46235291roil
sail45447161sail
soils55327981soils
sol37256621so_l
soli46637011soli
soul46435711soul
spoil75818651spoil
toil46536281toil
aboil72217542aboil
ail37171042_ail
anil46437432anil
aril45843022aril
assoil688542assoil
axil116424452axil
bail65042802bail
boils75427192boils
boll65634752boll
bowl96827702bowl
broil74918222broil
ceil65725062ceil
coal66939252coal
coif96337912coif
coils75030082coils
coin66645352coin
coir66327242coir
col59360352co_l
cool66940492cool
cowl97530812cowl
deil56231622deil
diol57329132diol
doily95321032doily
doit56347852doit
dol47150652do_l
doll56632492doll
evil75318072evil
fail74840242fail
fil65447142_fil
foal76630922foal
foils85025812foils
foin77231562foin
fool75330592fool
foul77027582foul
fowl105723632fowl
goal55829302goal
hail74839062hail
heil76328932heil
howl107625692howl
jail115529092jail
join116724832join
jowl146120302jowl
kail85131492kail
koel84519942koel
kohl113911712kohl
koi77534752koi_
kois85129402kois
loid55531492loid
loin46838722loin
loll46128382loll
mail65543452mail
mil55752112_mil
moils76125752moils
mol56654592mo_l
moll66735702moll
mool67533862mool
nail45838652nail
nil36144192_nil
noel45226552noel
noils55024332noils
noily86120992noily
noir46722432noir
oi29061482_oi_
oils46337972_oils
oily77932252_oily
owl66228972_owl
pail66141832pail
poi57244662poi_
poilu72316002poilu
pois66539042pois
pol56449382po_l
poll66332132poll
pool65835952pool
rail46147762rail
reoil55321182reoil
roils54826792roils
roily86121112roily
roll46331652roll
rotl45029682rotl
said55742112said
sails55738102sails
sain45551292sain
sal36462882s_al
sall44544682sall
saul45836522saul
scowl1012012972scowl
seal45654372seal
seel45042982seel
sei36048932sei_
seif75638732seif
seis45542392seis
sel38253322s_el
sell45840612sell
shiel811023772shiel
shill85325332shill
shily115222012shily
shim95827862shim
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
shoal83920272shoal
shool84523152shool
shorl84720252shorl
shul75823152shul
si29149572s_i_
sial45938832sial
sib56850312s_ib
sic55847872s_ic
sigil63515502sigil
sild55030582s_ild
silk85529322s_ilk
sill45545152sill
silo46037912s_ilo
silt46558192s_ilt
sim56553142s_im
sin36265892s_in
sip57656012s_ip
sir35746672s_ir
sis37360542s_is
sit35877752s_it
six105339742s_ix
ski74925692ski_
skid95720932skid
skill94316722skill
skim105322512skim
skin85927532skin
skip105421752skip
skirl96012912skirl
skis84825292skis
skit85437532skit
skoal93811462skoal
slid55828982slid
slily85820032slily
slim66631962slim
slip67031732slip
slit46250102slit
sloid64619712sloid
smile74823922smile
smit65138412smit
snail57020202snail
snib66522982snib
snip66424652snip
snit46342472snit
snool55118642snool
so28855442so__
soak87227662soak
soap65831132soap
soar46838672soar
sob57857942so_b
soba64927922soba
sobs64941752sobs
soca66330052soca
social8813332social
sock105233212sock
socle7419572socle
sod46053702so_d
soda56329382soda
sodic84917492sodic
sods54940212sods
sofa75625602sofa
soft76942822soft
soiled73822472soiled
soja115619512soja
soke85436262soke
sokol94612292sokol
sola45541862sola
sold54837412sold
sole46053672sole
solid65025082solid
solo45538942solo
sols45448162sols
som59153812so_m
soma65635292soma
some66040382some
soms66239372soms
son37761952so_n
sone46649982sone
song55133672song
sonic75225292sonic
sonly85718052sonly
sons46049552sons
sook84933392sook
soon46240502soon
soot45761062soot
sop57557862so_p
soph97024202soph
sops65244562sops
sora45746912sora
sorb68333042sorb
sord56237202sord
sore47059532sore
sorel56231442sorel
sori46039842sori
sorn46641062sorn
sort46264812sort
sos37761602so_s
sot310384302so_t
soth75932522soth
sotol54917652sotol
sots45552452sots
sou37853692so_u
souk86127172souk
souls55127362souls
soup66232912soup
sour45935892sour
sous46947212sous
sow66554762so_w
sown75127452sown
sows75342492sows
sox106444192so_x
soy67851452so_y
soya75724432soya
soys75233932soys
sozin14514542sozin
spail74921552spail
speil75618642speil
spic85227432spic
spiel74623912spiel
spik105419712spik
spile75230082spile
spill74821162spill
spilt75532222spilt
spin66231302spin
spit65545082spit
spiv95917792spiv
spoils84614532spoils
spoilt85016592spoilt
spool75219042spool
sri35634002sri_
sris45434152sris
stile54931572stile
still54922082still
stilt54831982stilt
stir45723252stir
stoic7317252stoic
stool55619892stool
suit45649872suit
swail86217162swail
swig85818022swig
swill83417372swill
swim96221402swim
swirl84514142swirl
syli74318982syli
tail45443652tail
til36350262_til
toile54626492toile
toils54527492toils
toit46353062toit
toll45535262toll
tool46735682tool
vail75432552vail
veil75523592veil
viol76523592viol
void86220562void
voila84813942voila
voile84719722voile
wail75238822wail
wool76427372wool
yowl105820952yowl
zoic152316072zoic
zoril143916692zoril

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.266671770.7
2DLD Change Limit298722770.79637527.6
3Display Results2772770.0634396.8
 (SQL Overall)1786912771.125158836.4
 
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.