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

215 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
falcated143847(None) 
falcate12311611falcate_
alated75625142_al_ated
baccated15148372baccated
defalcated1744182defalcated
faceted13509562fa_ceted
fasciated1546132fasciated
fellated1239562fellated
filiated12610082filiated
floated113312702f_loated
foliated1249912foliated
furcated1437592furcated
galeated104111572galeated
palmated132511002palmated
palpated13249762palpated
placated1338452placated
sulcated11310372sulcated
vacated1349352va_cated
valuated12239202valuated
abated95918453_a_bated
ablated102513443_ablated
acted88521733_a_c_ted
aerated85322373_aerated
alate55340323_al_ate_
alates64833963_al_ates
alcade91111513_alcade_
alcades101011473_alcades
alcaide1088453_alcaide
alcalde10104953_alcalde
alcayde13103723_alcayde
alcoved1375613_alcoved
alerted82512223_alerted
allayed11138063_allayed
allocated1248093allocated
ansated84214003_ansated
arcaded1178973_arcaded
arcuated1138803_arcuated
ascared10399523_ascared
aurated83817793_aurated
aviated11310263_aviated
baccate131011263baccate_
baldpated1543823baldpated
ballasted1245453ballasted
balloted1189043balloted
balsamed1344543balsamed
belated103520013bel_ated
bleated104015973_bleated
bloated104513433_bloated
calcanea1276273calcanea
calcanei1265263calcanei
calceate1239863calceate_
calcined1338743calcined
calcite11413783calcite_
calcites12313003calcites
calculated1577803calculated
calycate1537893calycate_
cascaded14135703cascaded
caseated11310713caseated
caudated1238063caudated
caveated1439133caveated
ciliated11510943ciliated
cleated103417843_cleated
collated113615063collated
colocated1439613colocated
dealated103213603deal_ated
defalcate1544923defalcate_
defalcates1644543defalcates
delated93722873del_ated
dilated93115823dil_ated
educated1237943educated
elated74725823_el_ated
evaluated13276653evaluated
fabricated1845403fabricated
fabulated1546323fabulated
facade1238803fa_cade_
facades1339033fa_cades
faced117727653fa_c__ed
facete115014833fa_cete_
facetted1445743facetted
faggoted1443103faggoted
fagoted1236073fa_goted
fainted114211723fa_inted
falafel1383903fal_afel
falces115216003falc__es
falconer1346033falconer
falconet13410353falconet
fallowed15127753fallowed
falter94519053fal__ter
faltered122810983faltered
fancied133310603fanc_ied
farced125216533farc__ed
farted105121783fa__rted
fasciate1347563fasciate_
fascinated1645873fascinated
fasted105320953fa__sted
fated95632133f___ated
fatted105419843fa__tted
faulted11227723fa_ulted
fellate10313433fellate_
fellates11312753fellates
felted103714653fel__ted
filched16307423filc_hed
fileted1159093fil_eted
filiate10414233filiate_
filiates11412653filiates
filleted1236603filleted
filtrated1345963filtrated
fixated1835533f_ixated
flacked173711583flac_ked
flaked144715653f_l_aked
flamed124618973f_l_amed
flared105317603f_l_ared
flatbed13397983f_l_atbed
flatted114012943f_latted
flaunted1234603flaunted
flawed134712723f_l_awed
flayed134414053f_l_ayed
fleeted113310233f_leeted
flinted114411893f_linted
flirted11428673f_lirted
flited104616583f_l_ited
flitted114011643f_litted
floatel10308013f_loatel
floater104413353f_loater
flouted113210813f_louted
fluted104917163f_l_uted
flyted13378773f_l_yted
folate93320393fol_ate_
folates103218453fol_ates
foliaged1344673foliaged
foliate10513533foliate_
foliates11412753foliates
foveated1536293foveated
fracted1339373frac_ted
furcate12310453furcate_
furcates1339873furcates
galatea839943gal_atea
galeate83916783galeate_
gallanted1145893gallanted
gallate83417123gallate_
gallates92815523gallates
galleted1038213galleted
gelated93615633gel_ated
glaciated1365753glaciated
gloated93511533_gloated
halted105019603hal__ted
labiated11109303labiated
lactated1138863lactated
lanated8313203la_nated
lanceted1137073lanceted
lariated91212063lariated
lated65240673__l_ated
located103114183_located
malate84624553mal_ate_
malates93522603mal_ates
maleate94117543maleate_
maleates103316343maleates
malted94819853mal__ted
mandated12310283mandated
mulcted12296693mulc_ted
narrated9310323narrated
oxalated1695323oxal_ated
palaced124110773pal_aced
palate84226783pal_ate_
palates93624933pal_ates
paleate94120003paleate_
palleted1139863palleted
palliated1238493palliated
palmate113215233palmate_
palpate113213923palpate_
palpates122613063palpates
pancaked1734893pancaked
pileated112711133pileated
placate11312433placate_
placater1238013placater
placates12311753placates
plated95225773_pl_ated
pleated103816633_pleated
plicated13310643plicated
pulsated1136853pulsated
radiated102512593radiated
radicated13410123radicated
related83327573rel_ated
relocated12710813relocated
saccate111311763saccate_
salaamed1134623salaamed
salivated1337473salivated
salted74121203sal__ted
saluted84511703sal_uted
salvaged1335353salvaged
satiated9311603satiated
slated75028313_sl_ated
solated83618023sol_ated
solvated12237443solvated
spicated13309903spicated
sulcate9314423sulcate_
sulfated1238833sulfated
tailcoated1343283tailcoated
tailgated1145123tailgated
talced93811003talc__ed
talcked1446343talc_ked
talented938423talented
tallaged10257923tallaged
unlocated1238383unlocated
vacate11314553va_cate_
vacates12312833va_cates
valeted1139013val_eted
validated1446493validated
vallate103016563vallate_
valuate102512733valuate_
valuates112811193valuates
valvate133710813valvate_
variated121211393variated
wauchted1753373wauchted
yachted1634853ya_chted

Search took 9 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 Limit1461622157.87618557.9
3Display Results2152150.0932311.8
 (SQL Overall)1786912158.12521992.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.