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

145 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
soilure73623(None) 
soilures836501soilures
colure8314162co_lure
failure1035752failure
seisure738192seisure
seizure1634682seizure
soilage8169352soilage
solute64016662so_lute
allure63012943_allure
boiler84319273boiler_
boilers93417063boilers
bordure1035783bordure
coenure968153coenure
coiffure1643123coiffure
coiler84421593coiler_
coilers93619903coilers
coinsure1046933coinsure
collude10337993collude
colures9315143co_lures
conjure16109073conjure
couture9310623couture
dilute72911803_dilute
doublure1142593doublure
epicure1136823epicure
failures1135163failures
figure10258833_figure
fixure16256543_fixure
goitre7349003goi_tre
guipure1043533guipure
gyplure13122013gyplure
inure54119053__inure
jointure15134833jointure
leisure736693leisure
ligure7279473_ligure
lure45142463___lure
moidore1056153moidore
moiler84017263moiler_
moilers93615203moilers
moire71017323moi__re
moisture1046653moisture
oiler54628283_oiler_
oilers64721193_oilers
oilier64417233_oilier
ordure756813_ordure
philtre12105213philtre
pilule8411123_pilule
poilu72316003poilu__
poilus82210573poilu_s
pollute937383pollute
posture9313253posture
roilier7311523roilier
rondure837313rondure
sailer63526103sailer_
sailers73822323sailers
sailor63113753sailor_
sailors73213723sailors
salute64418023s_alute
scalare93311833scalare
scissure1043273scissure
seclude1035233seclude
secure8513533s_ecure
seisures838273seisures
seizures1744633seizures
shire84727133shi__re
sieur5911893s_ieur_
sieurs659043s_ieurs
silage72715303s_ilage
silane62718053s_ilane
silkie103313403s_ilkie
siller64026063s_iller
silurid837013s_ilurid
silvae92811093s_ilvae
silver93815813s_ilver
sire46150413s_i__re
slue45332193s__lu_e
slur45525153s__lur_
slurb74116323s__lurb
slurp74014983s__lurp
slurs54123373s__lurs
smile74823923smil__e
smiler83916683smiler_
smilers94113853smilers
socle7419573socl__e
soigne74310033soi_gne
soignee8279133soignee
soil46138833soil___
soilages9189673soilages
soilborne1182413soilborne
soiled73822473soil_ed
soiling83422323soiling
soils55327983soil__s
soiree62919483soi_ree
sojourn1442893sojourn
solace83415823so_lace
solar55927343so_lar_
solate64526073so_late
solder73921343so_lder
sole46053673so_l__e
soleret7321233so_leret
solider82912453solider
solitude9105053solitude
solleret8512223solleret
soluble966103so_luble
solum74717613so_lu_m
solums85211333so_lums
solus54726983so_lu_s
solutes73515263so_lutes
solve85618943so_l_ve
solver94016703so_lver
sombre10729473so_mbre
sonlike112110713sonlike
sore47059533so___re
sour45935893so__ur_
source8410673so__urce
soured74921863so__ured
sourer63620213so__urer
sours55230503so__urs
souse56530773so__use
spicule11269933spicule
spile75230083spil__e
spiller92914333spiller
spinule9299993spinule
spire75828693spi__re
splore81611303s_plore
splurge1044763s_plurge
spoilage11195373spoilage
spoiler93310683spoiler_
spoilers10238633spoilers
stature74410683stature
stile54931573stil__e
stiller73414293stiller
stipule936723stipule
stoure64814943s_toure
sure45447413s___ure
suture6313203s_uture
swiller103211663swiller
toile54626493toil__e
toiler63918283toiler_
toilers74116263toilers
tonsure758783tonsure
torture738593torture
velure939773_velure
voile84719723voil__e
volume11358273vo_lume
volute93912763vo_lute

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271456.34321129.9
3Display Results1451450.0602416.7
 (SQL Overall)1786911456.80926243.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.