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

302 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
filiate1041423(None) 
ciliate9514601ciliate
filiated12610081filiated
filiates11412661filiates
foliate10513531foliate
affiliate1545322affiliate
ciliated11510952ciliated
ciliates10413452ciliates
dilate73220692dil_ate
falcate12311612falcate
fellate10313432fellate
filial93013252filia_l
filister1137402filister
filtrate1148222filtrate
finite9316822fini_te
fissate103010032fissate
fixate1638732fi_xate
flite85424962f_li_te
folate93320392fol_ate
foliage1147532foliage
foliated1249912foliated
foliates11412752foliates
militate10311672militate
pileate93815922pileate
silicate10312622silicate
vitiate103412952vitiate
ablate82219213abl_ate
affiliated1744193affiliated
affiliates1644893affiliates
airdate8311323airdate
alate55340323_al_ate
aplite8316393apli_te
arillate8412993arillate
aviate9315203_aviate
bifoliate1444313bifoliate
bilabiate1344573bilabiate
biliary1238213biliary
bilobate1247033bilobate
binate8419773bi_nate
bistate9313823bistate
blate75933783_bl_ate
blite76225353_bli_te
bullate93415073bullate
califate13310483califate
celibate1259313celibate
cilia73016763cilia__
ciliary1247923ciliary
ciliately1443953ciliately
cilice103213353cili_ce
ciliolate1145973ciliolate
cirrate92413493cirrate
citrate92216803citrate
climate11312833climate
collate92919683collate
defoliate1346993defoliate
delate73827753del_ate
delicate11315493delicate
deviate11312713deviate
dictate10311663dictate
digitate1098683digitate
dilatate947773dilatate
dilated93115823dil_ated
dilater83515653dil_ater
dilates83220663dil_ates
dilute72911803dil_ute
disrate81418523disrate
elate55335883_el_ate
elite56230183_eli_te
eluate62315433_eluate
epilate9314283epil_ate
exfoliate1954133exfoliate
expiate16910593expiate
faciae112913413facia_e
facilitate1544573facilitate
falcated1438473falcated
fasciate1347563fasciate
fate75444283f___ate
feline94820143feli_ne
fellated1239563fellated
fellates11312753fellates
felsite1039083felsite
feriae95618603feria_e
fermate122813003fermate
ferrate103014043ferrate
fiat76646643f__iat_
fiats85324483f__iats
figeater1236953figeater
figurate1237193figurate
fila74729133fil_a__
filar84819293fil_a_r
filaree10611213filaree
filariae1148473filaria_e
filature1145423fil_ature
file75446643fil___e
fileable13179223fileable
filename1344353filename
filet85540163fil_et_
fileted1159093fil_eted
filets94718953fil_ets
filially1447003filially
filiating1339243filiating
filiation121110243filiation
filibeg1353383filibeg
filicide1446363filicide
filigree1264663filigree
filing103823763fili_ng
filings115213073filings
filisters1237003filisters
fillable13179573fillable
fille84327403fil__le
fillet95027083fillet_
filleted1236603filleted
fillets103414753fillets
fillister1244423fillister
filmable15157133filmable
filmset1257513filmset
filose96112503fil_ose
filter94517633fil__ter
filth115015823fil__th
filtrated1345963filtrated
filtrates1247733filtrates
fimbriate1643823fimbriate
finale94116763fi_nale
finial92814183finia_l
finialed1255503finialed
finials103210153finials
finites10315923fini_tes
finito9310303fini_to
finlike14279063finli_ke
fixated1835533fi_xated
fixates1737393fi_xates
fixit154819303fixi_t_
fixity19427803fixi_ty
flake125119973f_l_ake
flame105124443f_l_ame
flare84823633f_l_are
flat77147823f_l_at_
flats86429743f_l_ats
flint87333503f_lint_
flinted114411893f_linted
flints95617453f_lints
flinty126112493f_linty
flirt87424753f_lirt_
flirted11428673f_lirted
flirter10318673f_lirter
flirts95411483f_lirts
flirty12499143f_lirty
flit76539273f_li_t_
flited104616583f_li_ted
flites95122443f_li_tes
flits85625223f_li_ts
flitted114011643f_litted
flitter103413903f_litter
float85928573f_loat_
floated113312703f_loated
floatel10308013f_loatel
floater104413353f_loater
floats96816253f_loats
floaty124210943f_loaty
flute86823753f_l_ute
flyte115713943f_l_yte
folates103218453fol_ates
folia83618933folia__
foliaged1344673foliaged
foliages1247623foliages
foliar93210973folia_r
foliolate1244873foliolate
foliose10378013foliose
fomite113314073fomi_te
formate123115093formate
fossate10388603fossate
foveate1338363foveate
frigate11311063frigate
fulminate1446553fulminate
fumigate1446153fumigate
furcate12310453furcate
galeate83916783galeate
gallate83417123gallate
gelate73421253gel_ate
goliath1145933goliath
halite93624233hali_te
humiliate1444973humiliate
ideate7313683_ideate
ilia46026823_ilia__
iliac75013493_ilia_c
iliad64613463_ilia_d
iliads7448673_iliads
ilial55317843_ilia_l
illite63414923_illite
imitate9310873_imitate
ingate73018243_ingate
initiate8412693initiate
inmate82917363_inmate
innate63917313_innate
iodate7313503_iodate
iolite63221983ioli_te
irate55627983_i_rate
kalifate1556493kalifate
labiate91313573labiate
late47560483__l_ate
liane54720663__liane
librate93214233librate
ligate72519253li_gate
limbate1139213limbate
lineate7815153lineate
liquate1638423liquate
lite47054543__li_te
litigate948303litigate
malate84624553mal_ate
maleate94117543maleate
mediate103415213mediate
migrate101314173migrate
milage93414123mil_age
mileage10299313mileage
milia72719573milia__
miliary1249463miliary
militated1248803militated
militates11310883militates
millage103112753millage
milliare1039153milliare
misate81222693mi_sate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
mitigate1148693mitigate
muriate9313363muriate
nictate9310223nictate
nidate7313783ni_date
niobate937703niobate
nitrate72017013nitrate
oblate82214743obl_ate
obligate11198303obligate
obviate1235783obviate
officiate1744163officiate
oleate6318883_oleate
oolite63319603ooli_te
opiate8513463_opiate
palate84226783pal_ate
paleate94120003paleate
palliate10311893palliate
palmate113215233palmate
palpate113213923palpate
pelite84323003peli_te
peltate92013773peltate
picrate112014143picrate
pileated112711133pileated
pillage103412603pillage
pinite8321243pini_te
pinnate93613743pinnate
pirate82322883pi_rate
plate74635113_pl_ate
plicate11314513plicate
polite83625073poli_te
pulsate9510233pulsate
radiate83416313radiate
relate64033633rel_ate
salivate11310013salivate
satiate7315403satiate
seriate73722473seriate
sibilate1049533sibilate
sigmate10710143sigmate
silage72715303sil_age
silane62718053sil_ane
silicates11311523silicates
silicle937753silicle
silique1645643silique
silvae92811093silva_e
sinuate7412163sinuate
situate7410783situate
slate55438283_sl_ate
solate64526073sol_ate
solvate102710213solvate
spoliate1039243spoliate
striate74218953striate
sulcate9314423sulcate
sulfate10311653sulfate
tailgate946823tailgate
tibiae838483tibia_e
tillage83111343tillage
tillite7313563tillite
titivate1146803titivate
titrate72215573titrate
toluate7159343toluate
validate1239003validate
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
variate101316433variate
velate93720143vel_ate
vibrate122811523vibrate
villae95615383villa_e
village113610833village
violate10311553violate
virgate1138733virgate
vitiated12289223vitiated
vitiates112311433vitiates
vittate10409733vittate
vizirate2045353vizirate
volvate13317993volvate
vulgate11388433vulgate
vulvate13388323vulvate
zincate1838533zincate

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 Limit1340273025.95322514.2
3Display Results3023020.1102745.5
 (SQL Overall)1786913026.46927622.7
 
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.