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

370 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
falcons123912(None) 
falcon11310291falcon_
flacons1238051flacons
bacons104917582ba_cons
balcony1435852balcony
ballons93916952ballons
daltons8310402daltons
falces115216002falc_es
falchions1743912falchions
falconer1346032falconer
falconers1445322falconers
falconet13410352falconet
falconets1444812falconets
falconry1642532falconry
fallows133713972fallows
fanions103713072fanions
fanons96115212fa_nons
felons93615762fel_ons
flacon1138632flacon_
flagons1137972flagons
gallons83015942gallons
garcons102411642garcons
gascons10289102gascons
halcyons1644022halcyons
halons95720712hal_ons
macons104017242ma_cons
mascons113411582mascons
racons84319342ra_cons
salmons93713252salmons
salons63823682sal_ons
saloons74415302saloons
talcous939482talcous
talions7314092talions
talons64019422tal_ons
acorns85013013_a_corns
aeons57624653_a_eons
aglycons1442973aglycons
agons66423783_a_gons
alans55636173_al_ans
alcids94812293_alcids
alcove1178083_alcove
alcoves1297873_alcoves
aldols7109713_aldols
alencons1045473_alencons
algins74816433_algins
algors7312553_algors
aliens65619213_aliens
aligns75312953_aligns
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
almond91410433_almond
almonds10127953_almonds
aloes54933673_al_oes
aloins65022203_aloins
alone55732963_al_one
along65419493_al_ong
altos55822953_alto_s
ancon75718233_ancon_
ancone83916953_ancone
ancones93116343_ancones
anions64123033_anions
anyons94513503_anyons
aprons8316993_aprons
archons12311583_archons
argons75018203_argons
arsons63917213_arsons
ascots85312513_ascots
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
azlons154110423_azlons
azons146518253_a_zons
baboons113211073baboons
bacon95620593ba_con_
balboas113710073balboas
balconies1347743balconies
baleens938473baleens
ballon84117493ballon_
balloons103110503balloons
ballots94116033ballots
bancos104713893banco_s
barons85025383ba_rons
baryons121010473baryons
basions94213953basions
batons85519423ba_tons
beacons11410733beacons
belons84119413bel_ons
billons93013353billons
blazons1836163blazons
bolsons969473bolsons
calcars11312653calcars
calces104420053calc_es
calcine11315273calcine
calcines12314753calcines
caldrons1138063caldrons
calicoes123911583calicoes
calicos113913493calico_s
calkins133814873calkins
callans94518473callans
callous93516593callous
calos74431903cal_o_s
calzone1848623calzone
calzones1948763calzones
camions113916133camions
cancans11311873cancans
cannons94412883cannons
canons85522063ca_nons
cantons95221203cantons
canyons124511593canyons
capons104119503ca_pons
carbons115418943carbons
cardons104519933cardons
cartons94122473cartons
cations94524143cations
claxons1635803claxons
clons75228133_cl_ons
colons86028673col_ons
cons66057693___cons
dacrons103211033dacrons
daemons10269233daemons
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
dalapons1145433dalapons
dalton7311273dalton_
damsons1038013damsons
deacons10310393deacons
etalons739063etal_ons
facers115519443fa_cers
faces106439433fa_c_es
facets116316653fa_cets
facias113415803fa_cias
facies113921593fa_cies
facing125321573fa_cing
facings134511263fa_cings
factions133013063factions
factors12912123factors
facts107021893fa_c_ts
fadeins1168503fadeins
fados95620733fa_do_s
faeces114713123faec_es
faggots1234853faggots
fagins10513863fa_gins
fagots1039963fa_gots
falcate12311613falcate
falchion1644333falchion_
falconine1445173falconine
falconoid1553153falconoid
falconries1543943falconries
fallals103310193fallals
fallen93813373fallen_
fallers103917993fallers
falling113621583falling
falloff1245953falloff
falloffs1343253falloffs
fallout10313503fallout
fallouts1137883fallouts
fallow124713853fallo_w
falls85727653fal__ls
falsies103515013falsies
falters103916473falters
famous11412393fa_mous
fancies124018783fancies
fandoms13229473fandoms
fanion94514323fanion_
fanon84619013fa_non_
fanos85926503fa_no_s
fans76247363fa___ns
fantods11177623fantods
fantoms12189153fantoms
farcers124713443farcers
farces115223323farc_es
farcies125317883farcies
farcing133514003farcing
faros85532023fa_ro_s
farrows13259783farrows
fasces114914543fasc_es
fascias1258413fascias
fascine12510583fascine
fascines13310143fascines
fashions1437243fashions
fastens105511753fastens
fathoms1537523fathoms
fatsoes10379423fatsoes
fatsos9389423fatso_s
fattens105111713fattens
fatuous1037783fatuous
faucals12326563faucals
fauces114916153fauc_es
faucets12578443faucets
fauns84516753fa__uns
favors124211403fa_vors
fawns115914263fa__wns
felloes104114373felloes
fellows134212433fellows
felon84619293fel_on_
felony123710323fel_ony
fiascoes13134923fiascoes
fiascos12124743fiasco_s
ficins113513983f_icins
ficoes114613463f_icoes
filches153410713filches
fillos94415073fillo_s
filos86125383fil_o_s
flacks154114533flac_ks
flagon1037983flagon_
flamens124611063flamens
flans85327973f_l_ans
flavins1338543flavins
flavone1335523flavone
flavones1435833flavones
flavors1337293flavors
flocks154713533f_locks
flocs105519233f_l_ocs
floes85528143f_l_oes
flogs95919963f_l_ogs
flong95815683f_l_ong
flongs105010493f_l_ongs
floods104511653f_loods
floors94112353f_loors
flops105920143f_l_ops
floss85118263f_l_oss
flows115822363f_l_ows
fluors94311373f_luors
foisons1047613foisons
folacins1337203folacins
folios93915463folio_s
folious103710723folious
follows13409923follows
fons76943893f___ons
frons86124043f__rons
fucous11399863f_ucous
fulvous1334543fulvous
fuscous1256673fuscous
fusions1039153fusions
futons93911513f_utons
fylfots1642423fylfots
gabions102410053gabions
gaboons10289893gaboons
galiots82311323galiots
galleons9258423galleons
gallon73715813gallon_
galloons9289683galloons
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galoots82410793galoots
galops94712613gal_ops
gammons1237973gammons
garcon92912483garcon_
garrons82713463garrons
gascon9339723gascon_
gerfalcons169903gerfalcons
gluons738503_gluons
gyrfalcons197813gyrfalcons
hadrons113314303hadrons
hagdons1258523hagdons
halcyon1543923halcyon_
halloas104318463halloas
halloes104021513halloes
halloos103716743halloos
hallos95425103hallo_s
hallows134417393hallows
haloes94623863hal_oes
halon86124863hal_on_
halos85230253hal_o_s
helicons1337613helicons
icons76516493__icons
jalops15329593jal_ops
jargons1558203jargons
kalians11310183kalians
kalong1177703kal_ong
kalongs1255443kal_ongs
kaons95014853ka__ons
kations114013663kations
kelsons1137323kelsons
klaxons1833263klaxons
ladrons83813193ladrons
lagoons839253lagoons
lallans74113533lallans
lardons83914493lardons
lions55923213__lions
loons55731723__loons
macon94519953ma_con_
macrons113514893macrons
maligns1038133maligns
malisons1048773malisons
malkins133311803malkins
mallows123714323mallows
maltols939403maltols
mammons1048513mammons
maroons92615553maroons
marrons93216973marrons
mascon103612743mascon_
mascots113910343mascots
masons83916513ma_sons
matrons93517633matrons
melons84117713mel_ons
meltons9410923meltons
narcos86714203narco_s
nasions73112383nasions
nations74720563nations
natrons73215663natrons
nelsons738003nelsons
neocons936913neocons
nylons9267973nyl_ons
oilcans936813oilcans
orlons6411013orl_ons
paeons83915523pa_eons
pallors9314343pallors
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patrons93818103patrons
pleons84213333_pleons
pylons113011233pyl_ons
raccoons1265453raccoons
racon75422143ra_con_
racoons93912433racoons
radons74118523ra_dons
ramsons939563ramsons
rancors9811373rancors
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
raucous938283raucous
rayons94113343ra_yons
recons84922993_recons
salchows1644203salchows
salicins10310933salicins
sallows103915543sallows
salmon84614183salmon_
salols64017873sal_ols
salon55228553sal_on_
saloon64418023saloon_
saloops93510133saloops
salvoes102811313salvoes
salvors103910903salvors
salvos94613383salvo_s
sarcous9312933sarcous
silicons10107143silicons
solions7513733solions
solons65120003sol_ons
tacos77023553ta_co_s
talcing103111633talcing
talcose938133talcose
talcs74817183talc__s
talcums1135513talcums
talion6317713talion_
tallols73311353tallols
tallows103313733tallows
talon55824113tal_on_
tampons112711553tampons
tarpons92612203tarpons
tauons63412673ta_uons
taxons134211503ta_xons
telcos8710683telco_s
telsons739203telsons
valors93413773val_ors
waggons1235503waggons
wagons103911213wa_gons
wallops123410413wallops
wallows133613533wallows
wanions104011373wanions
wantons103713013wantons
yapons114411773ya_pons
yaupons12345683yaupons
zircons1854963zircons

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.1561145455.1
2DLD Change Limit1340273706.17021722.4
3Display Results3703700.1402642.9
 (SQL Overall)1786913706.46627635.5
 
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.