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

237 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
moils7612575(None) 
boils75427191boils
coils75030081coils
foils85025811foils
mails76037781mails
mils66045331m_ils
moil65534091moil_
molls75129781molls
mols65948571mo_ls
mools76027171mools
noils55024331noils
oils46337971_oils
roils54826791roils
soils55327981soils
toils54527491toils
ails45654712_ails
anils56326722anils
arils58732202arils
axils127217502axils
bails75933522bails
boil66335182boil_
bolls75531312bolls
bowls106121432bowls
broils84114172broils
ceils75019402ceils
coals76129602coals
coifs105718702coifs
coil66439652coil_
coins75834552coins
coirs75221052coirs
cols66553082co_ls
cools75632632cools
cowls106922212cowls
deils65722862deils
diols65521012diols
doily95321032doily
doits66223672doits
dolls66126922dolls
dols56943052do_ls
emails84412342emails
evils84114262evils
fails85631482fails
fils75838692_fils
foals85721692foals
foil76433912foil_
foins85523382foins
fools86824202fools
fouls87221432fouls
fowls115518892fowls
goals65521292goals
hails85231642hails
heils85222192heils
hols76946292ho_ls
howls116219222howls
jails125422942jails
joins125818412joins
jowls156214522jowls
kails95525212kails
koels94613902koels
kohls12437802kohls
kois85129402koi_s
loids66220702loids
loins56728422loins
lolls512121732lolls
maids86327142maids
mail65543452mail_
maile75232222maile
mailes84329112mailes
maill74420792maill
maills84215282maills
maims96321792maims
mains75635112mains
mairs76228302mairs
malls76233432malls
marls75535162marls
mauls76524952mauls
meals75933372meals
mells75031332mells
mels65941532m_els
merls77423902merls
mewls105813232mewls
mibs85330482m_ibs
mics87435152m_ics
mids76541782m_ids
migs76935322m_igs
mil55752112m_il_
mild75330852m_ild
milds86422052m_ilds
mile66352572m_ile
miles74645072m_iles
milk105028472m_ilk
milks115020582m_ilks
mill66541482m_ill
mills75435052mills
milo65536102m_ilo
milos75428012m_ilos
milt65455812m_ilt
milts75430712m_ilts
mips85534082m_ips
mirs66940572m_irs
mis58162622m_i_s
miss65339422m_iss
moans74624372moans
moas65545342mo_as
moats75827642moats
mobile103613542mobile
mobiles112813122mobiles
mobs85737372mo_bs
mocks135023822mocks
mocs85834902mo_cs
modals93914452modals
models94216352models
modes85537412modes
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
moguls948552moguls
mohels115011322mohels
moiled94318862moiled
moiler84017262moiler
moilers93615202moilers
moira71012022moira
moire71017322moire
moires8915632moires
moist76033582moist
mojos145314462mojos
mokes114631032mokes
mol56654592mo_l_
mola66035632mo_la
molas75132092molas
mold76034332mo_ld
molds85324832molds
mole66251832mo_le
moles74747922moles
molies84429512molies
moll66735702mo_ll
molly105222492molly
molt66356162mo_lt
molts76032092molts
moly96031912mo_ly
momes95134472momes
moms86539482mo_ms
momus96116112momus
monas74732152monas
monies83233162monies
monks116123392monks
monos75930862monos
mons68152262mo_ns
moods85224622moods
mool67533862mool_
moola75117032moola
moolas83615592moolas
moons75331002moons
moors74923142moors
moos66051302mo_os
moots75831662moots
mopes95134982mopes
mops85940132mo_ps
morals85324632morals
moras76438772moras
morels84820012morels
mores76249642mores
morns75527442morns
mors65950062mo_rs
morts75533562morts
mos57067122mo__s
mosks116117002mosks
moss67641032mo_ss
mosts76028542mosts
motels83616892motels
motes75944002motes
moths106021552moths
motifs1139672motifs
motile83818342motile
motiles93317432motiles
mots66853162mo_ts
motts76527002motts
moues75732842moues
mould86015752mould
moulds94910992moulds
moult74728722moult
moults84713702moults
moves106128422moves
movies115118452movies
mows96340832mo_ws
moxas145014392moxas
moxies154317402moxies
mozos165516332mozos
mulls75124152mulls
nails55730402nails
nils46132452_nils
noels56418702noels
noil46133242noil_
noily86120992noily
noirs55615462noirs
oil37452052_oil_
oily77932252_oily
omits75018262omits
owls76022932_owls
pails75833062pails
poilu72316002poilu
poilus82210572poilus
pois66539042poi_s
polis74731162polis
polls74627722polls
pols66044562po_ls
pools74427702pools
rails55937402rails
reoils64516872reoils
roil46235292roil_
roily86121112roily
rolls55326232rolls
rotls55620162rotls
sails55738102sails
soil46138832soil_
sols45448162so_ls
souls55127362souls
spoils84614532spoils
tails55634192tails
tils45739612_tils
toil46536282toil_
toile54626492toile
toiles63923512toiles
toits55327472toits
tolls54728432tolls
tools55325242tools
vails85825932vails
veils84918802veils
viols86118102viols
voids95414672voids
voila84813942voila
voile84719722voile
voiles94616442voiles
wails86631482wails
wools84421462wools
yowls115715432yowls
zorils153810882zorils

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 Filter178691538000.343520965.0
2DLD Change Limit538002371.70331591.3
3Display Results2372370.0633761.9
 (SQL Overall)1786912372.10984727.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.