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

235 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
filiated1261008(None) 
ciliated11510951ciliated
filiate10414231filiate_
filiates11412661filiates
foliated1249911foliated
affiliated1744192affiliated
ciliate9514602ciliate_
ciliates10413452ciliates
dilated93115822dil_ated
falcated1438472falcated
fellated1239562fellated
fileted1159092fil_eted
filister1137402filister
filleted1236602filleted
filtrated1345962filtrated
finialed1255502finialed
fixated1835532fi_xated
flinted114411892f_linted
flirted11428672f_lirted
flited104616582f_li_ted
flitted114011642f_litted
floated113312702f_loated
foliaged1344672foliaged
foliate10513532foliate_
foliates11412752foliates
militated1248802militated
pileated112711132pileated
vitiated12289222vitiated
ablated102513443abl_ated
affiliate1545323affiliate_
affiliates1644893affiliates
afflicted1843433afflicted
airlifted1343193airlifted
alated75625143_al_ated
aviated11310263_aviated
belated103520013bel_ated
billeted1137643billeted
bilobated1444973bilobated
bilsted1038033bil_sted
bleated104015973_bleated
bloated104513433_bloated
ciliately1443953ciliately
citrated112712253citrated
cleated103417843_cleated
collated113615063collated
defoliated1545833defoliated
delated93722873del_ated
delisted10310563delisted
deviated13311043deviated
dictated1239203dictated
digitated1286963digitated
dilate73220693dil_ate_
dilater83515653dil_ater
dilates83220663dil_ates
diluted9248933dil_uted
disrated10915573disrated
elated74725823_el_ated
enlisted978193enlisted
epilated11310753epil_ated
exfoliated2163393exfoliated
expiated18168523expiated
facilitated1753643facilitated
fainted114211723f_ainted
falcate12311613falcate_
fasciated1546133fasciated
fated95632133f___ated
feinted11379623f_einted
fellate10313433fellate_
fellates11312753fellates
felted103714653fel__ted
fidgeted1443893fidgeted
figeater1236953figeater
filaree10611213fil_aree
filched16307423fil_ched
filed95331903fil___ed
filial93013253filia__l
filially1447003filially
filiating1339243filiating
filiation121110243filiation
filibeg1353383fili_beg
filicide1446363filicide
filigree1264663filigree
filigreed1482443filigreed
filisters1237003filisters
filled104922263fil__led
filliped1435223filliped
fillister1244423fillister
filmed124610363fil__med
filter94517633fil__ter
filtered12259043filtered
filtrate1148223filtrate_
filtrates1247733filtrates
fimbriated1843103fimbriated
finished1536483finished
finite9316823fini_te_
finites10315923fini_tes
fissate103010033fissate_
fisted104218703f__isted
fitted104716663f__itted
fixate1638733fi_xate_
fixates1737393fi_xates
flailed1137303f_lailed
flaked144715653f_l_aked
flamed124618973f_l_amed
flared105317603f_l_ared
flatbed13397983f_l_atbed
flatted114012943f_latted
flawed134712723f_l_awed
flayed134414053f_l_ayed
fleeted113310233f_leeted
flicked174610673f_licked
flied96519433f_li__ed
flighted1646973flighted
flipped15358513f_lipped
flirter10318673f_lirter
flite85424963f_li_te_
flites95122443f_li_tes
flitter103413903f_litter
floatel10308013f_loatel
floater104413353f_loater
floriated1347023floriated
flouted113210813f_louted
fluted104917163f_l_uted
flyted13378773f_l_yted
foisted113210603f_oisted
folate93320393fol_ate_
folates103218453fol_ates
foliage1147533foliage_
foliages1247623foliages
folioed1138033foli_oed
foveated1536293foveated
fritted113611333f_ritted
fruited11389093frui_ted
fulminated1645023fulminated
fumigated1644723fumigated
furcated1437593furcated
galeated104111573galeated
gelated93615633gel_ated
glinted9399373_glinted
gloated93511533_gloated
hilted104016043hil__ted
humiliated1643983humiliated
ideated9310973_ideated
iliad64613463_ilia__d
imitated1138263_imitated
initiated10510113initiated
iodated9310023_iodated
jilted144111353jil__ted
kilted113613833kil__ted
labiated11109303labiated
lariated91212063lariated
lated65240673__l_ated
librated113110313librated
lifted104413523__lifted
ligated92414143li_gated
lilied73913213lili__ed
lilted73715373__lilted
limited102310233limi_ted
lineated9711063lineated
linted74021823__linted
liquated1835493liquated
listed74322833__listed
litigated1146563litigated
mediated123011873mediated
migrated121110513migrated
militate10311673militate_
militates11310883militates
milted93919943mil__ted
misdated121211123misdated
mismated131111333mismated
misrated111315383misrated
mitigated1347083mitigated
muriated1139793muriated
nictated1137793nictated
nidated939863ni_dated
nitrated92213153nitrated
obligated13186903obligated
obviated1444563obviated
officiated1943253officiated
opiated1039483_opiated
palliated1238493palliated
palmated132511003palmated
palpated13249763palpated
picrated132110113picrated
pileate93815923pileate_
pillaged12298093pillaged
pillared11228093pillared
piloted10310323pil_oted
pinnated11338553pinnated
pirated102515613pi_rated
pixilated1944543pixilated
plaited103713893_plaited
plated95225773_pl_ated
pleated103816633_pleated
plicated13310643plicated
pulsated1136853pulsated
radiated102512593radiated
related83327573rel_ated
relisted9312623relisted
salivated1337473salivated
satiated9311603satiated
seriated92717023seriated
sibilated1246713sibilated
silicate10312623silicate_
silicates11311523silicates
silted74020013sil__ted
sinuated938413sinuated
situated938033situated
slated75028313_sl_ated
slitted83513313_slitted
solated83618023sol_ated
solvated12237443solvated
splinted11369253splinted
spoliated1246913spoliated
striated93414153striated
sulcated11310373sulcated
sulfated1238833sulfated
tailgated1145133tailgated
tilted74616863til__ted
titivated1345443titivated
titrated92611683titrated
tritiated1047523tritiated
unciliated1348053unciliated
unlisted9311153unlisted
uplifted1454423uplifted
validated1446493validated
valuated12239203valuated
variated121211393variated
vibrated14228393vibrated
vilified1547243vilified
violated1237883violated
visited1168773visi_ted
vitiate103412953vitiate_
vitiates112311433vitiates
wilted103915713wil__ted

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.1561145455.1
2DLD Change Limit1461622356.75021653.6
3Display Results2352350.0932526.9
 (SQL Overall)1786912356.99925530.9
 
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.