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

264 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
falcate1231161(None) 
falcated1438471falcated
alate55340322_al_ate
alcade91111512_alcade
baccate131011262baccate
calceate1239862calceate
calcite11413782calcite
calycate1537892calycate
defalcate1544922defalcate
facade1238802fa_cade
facete115014832fa_cete
fasciate1347562fasciate
fellate10313432fellate
filiate10414232filiate
folate93320392fol_ate
foliate10513532foliate
furcate12310452furcate
galeate83916782galeate
gallate83417122gallate
malate84624552mal_ate
maleate94117542maleate
palate84226782pal_ate
paleate94120002paleate
palmate113215232palmate
palpate113213922palpate
placate11312432placate
saccate111311762saccate
sulcate9314422sulcate
vacate11314552va_cate
vallate103016562vallate
valuate102512732valuate
valvate133710812valvate
abate76627843_a_bate
ablate82219213_ablate
acuate8315633_acuate
acute74720363_a_cute
adnate72913483_adnate
aerate64830553_aerate
aflame1138723afl_ame
afloat9315153afloat_
agate66525143_a_gate
agnate73314873_agnate
alae45643753_al_a_e
alane56135613_al_ane
alated75625143_al_ated
alates64833963_al_ates
albata839333_albata
albite8313313_albite
alcades101011473_alcades
alcaic1039983_alcaic
alcaide1088453_alcaide
alcalde10104953_alcalde
alcayde13103723_alcayde
alcove1178083_alcove
algae65319623_alga_e
alkane104313323_alkane
allocate10411023allocate
analcite1049333analcite
ansate64517863_ansate
arcade91013643_arcade
arcane81216743_arcane
arcuate9311963_arcuate
aurate64426473_aurate
aviate9315203_aviate
baccae12119703bacca_e
baccated15148373baccated
balata8614673bal_ata
baldpate1345483baldpate
ballade104012563ballade
ballute938543ballute
barbate11314543barbate
blate75933783_bl_ate
bullate93415073bullate
calcanea1276273calcanea
calcanei1265263calcanei
calcar10312753calca_r
calcarate1347703calcarate
calcars11312653calcars
calcine11315273calcine
calcites12313003calcites
calculate1389873calculate
califate13310483califate
calotte9510563calotte
carate84734003ca_rate
carcase11312733carcase
cascade12118603cascade
caseate9314783caseate
cate66254593___cate
caudate10311353caudate
ciliate9514603ciliate
clavate1238713clavate
collate92919683collate
colocate12313433colocate
dacite91115883da_cite
daycare1355093daycare
dealate83617843deal_ate
defalcated1744183defalcated
defalcates1644543defalcates
delate73827753del_ate
delicate11315493delicate
dilate73220693dil_ate
educate10310213educate
elate55335883_el_ate
eluate62315433_eluate
evaluate11287793evaluate
fabricate1646833fabricate
fabulate1339203fabulate
facades1339033fa_cades
face96140123fa_c__e
facet106038523fa_cet_
faceted13509563fa_ceted
facets116316653fa_cets
faciae112913413fa_ciae
facile112514883fa_cile
fact97142543fa_c_t_
facts107021893fa_c_ts
faecal11359813faeca_l
falafel1383903fal_afel
falbala1235873falbala
falces115216003falc_es
falcon11310293falc_on
falconer1346033falconer
falconet13410353falconet
falcons1239123falcons
fallacy1536433fallacy
fallal93612693falla_l
fallals103310193fallals
false84818123fal__se
falsie93513853fal_sie
falsity1335903falsity
falter94519053fal__ter
fanfare1336673fanfare
farce104925323farc__e
farcie114816473farc_ie
fasciae1247523fasciae
fasciated1546133fasciated
fascinate1447763fascinate
fascine12510583fascine
fate75444283f___ate
faucal11339963fauca_l
faucals12326563faucals
faucet115816553faucet_
faucets12578443faucets
faunae95210373fauna_e
fellated1239563fellated
fellates11312753fellates
felsite1039083felsite
fermate122813003fermate
ferrate103014043ferrate
filiated12610083filiated
filiates11412663filiates
filtrate1148223filtrate
fissate103010033fissate
fixate1638733f_ixate
flake125119973f_l_ake
flame105124443f_l_ame
flare84823633f_l_are
flat77147823f_l_at_
flatmate1346393flatmate
flats86429743f_l_ats
flite85424963f_l_ite
float85928573f_loat_
floated113312703f_loated
floatel10308013f_loatel
floater104413353f_loater
floats96816253f_loats
floaty124210943f_loaty
flute86823753f_l_ute
flyte115713943f_l_yte
folates103218453fol_ates
foliage1147533foliage
foliated1249913foliated
foliates11412753foliates
formate123115093formate
fossate10388603fossate
foveate1338363foveate
frigate11311063frigate
furcated1437593furcated
furcates1339873furcates
galatea839953gal_atea
galeae74717453galea_e
galeated104111573galeated
galette84212693galette
gallates92815523gallates
gelate73421253gel_ate
glaciate1168073glaciate
halite93624233hal_ite
hamate113319833ha_mate
hastate10313913hastate
kalifate1556493kalifate
karate105320923ka_rate
labiate91313573labiate
lactate9312693lactate
lanate6421263la_nate
late47560483__l_ate
locate83919843_locate
magnate10512703magnate
malates93522603mal_ates
maleates103316343maleates
maltase938903maltase
mammate104411273mammate
mandate10315573mandate
marcato1139743marcato
narrate7313493narrate
oatcake1345363oatcake
oblate82214743obl_ate
oleate6318883_oleate
oxalate1457623oxal_ate
palace104516913pal_ace
palates93624933pal_ates
paleae84820293palea_e
palette93613983palette
palliate10311893palliate
palmated132511003palmated
palpated13249763palpated
palpates122613063palpates
pancake1536673pancake
peltate92013773peltate
pileate93815923pileate
placated1338453placated
placater1238013placater
placates12311753placates
planate9314573planate
plate74635113_pl_ate
plicate11314513plicate
pulsate9510233pulsate
radiate83416313radiate
radicate11412873radicate
ramate83921683ra_mate
relate64033633rel_ate
relocate10713533relocate
saccade12107033saccade
salivate11310013salivate
salpae84614273salpa_e
salute64418023sal_ute
salvage1138193salvage
satiate7315403satiate
savate9313783sa_vate
silicate10312623silicate
slate55438283_sl_ate
solate64526073sol_ate
solvate102710213solvate
spicate113214193spicate
sulcated11310373sulcated
sulfate10311653sulfate
tailgate946823tailgate
talcose938133talcose
tallage82712073tallage
tannate71813523tannate
thecate123210023thecate
toccate1138773toccate
toluate7159343toluate
vacated1349353va_cated
vacates12312833va_cates
valerate11311473valerate
validate1239003validate
valuated12239203valuated
valuates112811203valuates
variate101316433variate
velate93720143vel_ate
volvate13317993volvate
vulgate11388433vulgate
vulvate13388323vulvate
zincate1838533zincate

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272647.58017681.7
3Display Results2642640.466566.5
 (SQL Overall)1786912648.20221786.3
 
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.