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

147 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
failures113516(None) 
failure1035751failure_
allures72913112_allures
factures13129022factures
failles102914132fail_les
figures11239112f_igures
fixures17596062f_ixures
soilures836502soilures
abjures1636523_abjures
adjures1536233_adjures
affluxes2142533affluxes
alludes83610333_alludes
allure63012943_allure_
allured8299173_allured
allurer7348433_allurer
allurers8286773_allurers
armures9510273_armures
assures7611403_assures
aures55137093_a__ures
azures15510183_a_zures
bailees93914383bail_ees
bailers94221353bailer_s
bailies94120203bail_ies
bailors93212413bailor_s
ballutes1037523ballutes
caiques18248793caiqu_es
calibres1237103calibres
calluses1039323calluses
captures1239443captures
colures9315143_colures
dailies84219263dail_ies
dasyures1254153dasyures
dilutes82911973_dilutes
epicures1246513epicures
fablers124812613fabler_s
fables114921673fabl__es
facture12108923facture_
faiences1337043faiences
failed105421603fail__ed
failings123811013failings
faille93414743fail_le_
fails85631483fail___s
fainters11349693fainters
faired105915773fai__red
fairer95212063fai__rer
fairest10412293fai__rest
fairies103516043fai_ries
fairs85825443fai__r_s
faitours1134263faitour_s
falces115216003fa_l_ces
fallers103917993faller_s
falsies103515013fa_lsies
falters103916473fa_lters
families1339443famil_ies
fanfares1436773fanfares
fares85852873fa___res
farles96025783farl__es
fatigues1244193fatigu_es
fauces114916153fa__uces
fauves125610423fa__uves
favoured1533963favoured
favourer1443823favourer
favourers1543123favourers
favours13437093favour_s
favuses1336183fa_vuses
features11310333features
fiacres1237253f_iacres
fibres114312123f_i_bres
ficuses12159203f_icuses
figure10258833f_igure_
figured12196473f_igured
figurer11215863f_igurer
figurers12254873f_igurers
filaree10611213f_ilaree
filarees1187643f_ilarees
filatures1245853f_ilatures
filches153410723f_ilches
filers94623723f_iler_s
files85441273f_il__es
fillers104320213f_illers
filles94224523f_il_les
fillies103420253f_illies
filmers124211293f_ilmers
filters103816553f_ilters
fiques1837973f_iqu_es
fires85740753f_i__res
fissures1136573fissures
fixtures1835283fixtures
fixure16256543f_ixure_
flares94521703f__lares
flexures1843423flexures
flues84626923f__lu_es
flukes135114193f__lukes
flumes115119733f__lumes
flutes95421783f__lutes
fluxes165212933f__luxes
fractures14147233fractures
frailties1245853frailties
frillers11349873frillers
furfures1445663furfures
futures10310263f_utures
galeres83514333ga_leres
galluses936963galluses
galores82614323ga_lores
guipures1143733guipures
gyplures14102153gyplures
hachures1645873hachures
hailers104017263hailer_s
halluces1335613halluces
inures63318953__inures
jailers144114043jailer_s
jailors14328753jailor_s
leisures836683leisures
ligures8269893_ligures
lures56138533___lures
mailers94420333mailer_s
mailes84329113mail__es
manicures1346263manicures
manures9313353ma_nures
matures9314303ma_tures
nailers73215893nailer_s
natures7311963na_tures
parures9512693pa_rures
pastures10311963pastures
philtres1396513philtres
pilules9510623_pilules
railbuses1143623railbuses
railers74420663railer_s
raptures1037573raptures
rasures7312013ra_sures
sailers73822323sailer_s
sailors73213723sailor_s
salutes73716253sa_lutes
seisures838273seisures
seizures1744633seizures
soilure736233soilure_
tailers73720183tailer_s
tailles72516473tail_les
tailored936203tailored
tailors73212393tailor_s
taluses7311213ta_luses
valuers10328943va_luers
values94314943va_lu_es
velures1039093_velures
waftures1434853waftures
wailers103916803wailer_s
zaires1539703zai__res

Search took 8 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.420425454.8
2DLD Change Limit1461621477.40619735.6
3Display Results1471470.0463195.7
 (SQL Overall)1786911477.87222699.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.