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

160 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
failure103575(None) 
failures1135161failures
allure63012942_allure
facture12108922facture
faille93414742fail_le
figure10258832f_igure
fixure16256542f_ixure
soilure736232soilure
abjure1536743_abjure
adjure1435843_adjure
afire86215913afi__re
aglare7312423_aglare
allude73910903_allude
allured8299173_allured
allurer7348433_allurer
allures72913113_allures
armure8710133_armure
assure6610773_assure
azure14911483_a_zure
bailee84526013bail_ee
bailer85425253bailer_
bailers94221353bailers
bailie83818363bail_ie
bailor83412603bailor_
bailors93212413bailors
ballute938543ballute
caique17318803caiqu_e
calibre1136603calibre
capture1138913capture
colure8314163_colure
dasyure1153823dasyure
dilute72911803_dilute
epicure1136823epicure
fable105824753fabl__e
fabler116115813fabler_
fablers124812613fablers
facile112514883facil__e
factures13129023factures
faculae123210353faculae
fadlike15318483fadlike
faience1237513faience
fail74840243fail___
failed105421603fail_ed
failing113521333failing
failles102914133failles
fails85631483fail__s
fainer94717243fainer_
fainter103611053fainter
fair76332523fai__r_
faired105915773fai__red
fairer95212063fai__rer
fairs85825443fai__rs
fairy115318283fai__ry
faitour1034883faitour_
faitours1134263faitours
faller94621233faller_
fallers103917993fallers
false84818123fa_l_se
falser93912413fa_lser
falsie93513853fa_lsie
falter94519053fa_lter
fanfare1336673fanfare
fanlike142610503fanlike
fare76354463fa___re
farle86929243farl__e
fatigue1144393fatigu_e
fatlike142911193fatlike
fauve114712073fa__uve
favour12438333favour_
favoured1533963favoured
favourer1443823favourer
favours13437093favours
feature1039853feature
fiacre1137623f_iacre
fibre104812843f_i_bre
figured12196473f_igured
figurer11215863f_igurer
figures11239113f_igures
filar84819293f_ilar_
filaree10611213f_ilaree
filature1145423f_ilature
file75446643f_il__e
filer85433003f_iler_
filers94623723f_ilers
fille84327403f_il_le
filler94623623f_iller
filmer114112403f_ilmer
filose96112503f_ilose
filter94517633f_ilter
filum105015433f_ilu_m
fique1739143f_iqu_e
fire76245593f_i__re
fissure1036783fissure
fixture1734963fixture
fixures17596063f_ixures
flare84823633f__lare
flexure1743413flexure
flue75329853f__lu_e
fluke125016893f__luke
flume106021173f__lume
flute86823753f__lute
fracture13147123fracture
frailer10319943frailer_
friller104111743friller
future939563f_uture
galere73716673ga_lere
galore73514853ga_lore
guipure1043533guipure
gyplure13122013gyplure
hachure1545723hachure
hailer94720343hailer_
hailers104017263hailers
inure54119053__inure
jailer134316683jailer_
jailers144114043jailers
jailor13418573jailor_
jailors14328753jailors
leisure736693leisure
ligure7279473_ligure
lure45142463___lure
maigre9309163mai_gre
maile75232223mail__e
mailer84724183mailer_
mailers94420333mailers
malgre9299303ma_lgre
manicure1245803manicure
manure8313653ma_nure
mature8313463ma_ture
nailer64119363nailer_
nailers73215893nailers
nature6311263na_ture
parure8312523pa_rure
pasture9311463pasture
philtre12105213philtre
pilule8411123_pilule
railer64524933railer_
railers74420663railers
rapture937383rapture
rasure6311423ra_sure
sailer63526103sailer_
sailers73822323sailers
sailor63113753sailor_
sailors73213723sailors
salute64418023sa_lute
seisure738193seisure
seizure1634683seizure
soilures836503soilures
tailer63823733tailer_
tailers73720183tailers
taille63116923tail_le
tailor63412503tailor_
tailored936203tailored
tailors73212393tailors
value85719093va_lu_e
valuer93911443va_luer
velure939773_velure
wafture1334853wafture
wailer93720323wailer_
wailers103916803wailers
zaire14311993zai__re

Search took 10 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.1401276364.3
2DLD Change Limit1340271609.08014760.7
3Display Results1601600.0463478.3
 (SQL Overall)1786911609.26619284.6
 
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.