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 “soilures” with Change Limit: [1] [2] [3]

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

135 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
soilures83650(None) 
soilure736231soilure_
colures9315142co_lures
failures1135162failures
seisures838272seisures
seizures1744632seizures
soilages9189672soilages
solutes73515262so_lutes
allures72913113_allures
boilers93417063boiler_s
boluses94113833bo_luses
bordures1136173bordures
coenures1048683coenures
coiffures1743213coiffures
coilers93619903coiler_s
coinsures1136723coinsures
coituses1039623coituses
colludes11279223colludes
colure8314163co_lure_
conjures17119913conjures
coutures10311993coutures
dilutes82911973_dilutes
doilies84017363doil_ies
doublures1242573doublures
epicures1246513epicures
failure1035753failure_
figures11239113_figures
fixures17596063_fixures
goitres8389563goi_tres
guipures1143733guipures
gyplures14102153gyplures
inures63318953__inures
jointures16124873jointures
leisures836683leisures
ligures8269893_ligures
lures56138533___lures
moidores1156343moidores
moilers93615203moiler_s
moires8915633moi__res
moistures1147323moistures
oilers64721193_oiler_s
ordures856473_ordures
philtres1396513philtres
pilules9510623_pilules
poilus82210573poilu__s
pollutes1037613pollutes
postures10313783postures
rondures937713rondures
sailers73822323sailer_s
sailors73213723sailor_s
salutes73716253s_alutes
scalares103210983scalares
scissures1143323scissures
secludes1134953secludes
secures9613163s_ecures
seisure738193seisure_
seizure1634683seizure_
shires95225573shi__res
sieurs659043s_ieur_s
silages82514443s_ilages
silanes72517163s_ilanes
silexes1438653s_ilexes
silkies113715693s_ilkies
sillers73822103s_illers
sillies73425083s_illies
silurid837013s_ilurid
silurids945103s_ilurids
silvers104714043s_ilvers
sinuses73011593s_inuses
sires55945373s_i__res
situses72710493s_ituses
slues54527173s__lu_es
slurbs8439743s__lurbs
slurps84410003s__lurps
slurs54123373s__lur_s
smilaxes1744653smilaxes
smilers94113853smiler_s
smiles84522293smil__es
socles8418453socl__es
soilage8169353soilage_
soiled73822473soil__ed
soilless8279033soilless
soils55327983soil___s
soiree62919483soi__ree
soirees72411643soi_rees
sojourns1542313sojourns
solaces93116133so_laces
solates73523853so_lates
solders83517773so_lders
soleret7321233so_leret
solerets839693so_lerets
soles55547923so_l__es
soleuses838073soleuses
solitudes10105013solitudes
solleret8512223solleret
sollerets945263sollerets
solubles1065893so_lubles
solums85211333so_lu_ms
solus54726983so_lu__s
solute64016663so_lute_
solvers104414253so_lvers
solves95018223so_l_ves
sores55454283so___res
sources9312173so__urces
soured74921863so__ured
sourer63620213so__urer
sourest7515713so__urest
sours55230503so__ur_s
souses64229243so__uses
soyuzes1932953so_yuzes
spicules12219803spicules
spiles84227913spil__es
spillers103311703spillers
spinules10249333spinules
spires84628113spi__res
splores91910953s_plores
splurges1145163s_plurges
spoilages12184713spoilages
spoilers10238633spoiler_s
statures83711113statures
stiles64328773stil__es
stipules1037053stipules
stoures74614163s_toures
styluses11204773styluses
sutures7314223s_utures
swillers11299113swillers
toilers74116263toiler_s
toiles63923513toil__es
tonsures869133tonsures
tortures838913tortures
troiluses944553troiluses
velures1039093_velures
voiles94616443voil__es
volumes12298233vo_lumes
volutes102710983vo_lutes

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621357.66019081.2
3Display Results1351350.0462934.8
 (SQL Overall)1786911358.14221946.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.