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 “falconer” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
falconer134603(None) 
falconers1445321falconers
falconet13410351falconet
almoner949382_almoner
falcon11310292falcon__
falconets1444812falconets
falconry1642532falconry
falcons1239122falcon_s
alcove1178083_alcove_
alcoved1375613_alcoved
alcoves1297873_alcoves
aliener71011193_aliener
aligner8108313_aligner
aliner65621983_al_iner
allover1038583_allover
almner85710723_al_mner
almoners1068133_almoners
alone55732963_al_one_
ancone83916953_ancone_
ancones93116343_ancones
atoner64817193_a_toner
balconied1444843balconied
balconies1347743balconies
balcony1435853balcon_y
ballonet10314503ballonet
balloter1078893balloter
baloney1237483bal_oney
blazoner1944133blazoner
calcanea1276283calcanea
calcanei1265273calcanei
calcine11315273calcine_
calcined1338743calcined
calcines12314753calcines
callower13159073callower
caloyer1238143cal_oyer
calzone1848623calzone_
calzones1948763calzones
cloner84418093_cl_oner
facer105525053fa_c__er
fagoter1135883fa_goter
fainer94717243fa__iner
falcate12311613falcate_
falcated1438473falcated
falces115216003falc__es
falconine1445173falconine
falconoid1553153falconoid
falconries1543953falconries
faller94621233fal__ler
fallowed15127753fallowed
falser93912413fal__ser
falter94519053fal__ter
falterer11239853falterer
fancier123412063fanc_ier
fanner94218183fa__nner
farcer115016083farc__er
fascine12510583fascine_
fascines13310143fascines
fashioner15114323fashioner
fastener11227833fastener
fathomer1645293fathomer
fattener11268113fattener
favorer1355883fa_vorer
fawner125910463fa__wner
filcher15377793filc_her
flacon1138633flacon__
flacons1238053flacon_s
flavone1335523flavone_
flavones1435833flavones
flavorer1454553flavorer
flooder11258463f_looder
floorer10248073f_loorer
flower124815503f_l_ower
flyover1633513f_lyover
follower14137073follower
galloper11137183galloper
gammoner1345153gammoner
hallower14139813hallower
jaconet16311483ja_conet
jawboner20133363jawboner
larcener1036493larcener
loner55431043__l_oner
maligner11115333maligner
parcener1238473parcener
pardoner11189443pardoner
ratooner887003ratooner
sallower11139503sallower
talcose938133talcose_
taloned8310223tal_oned
waggoner1343423waggoner
wagoner1136093wa_goner
walkover1842943walkover
walloper13147113walloper
wallower14158933wallower
wantoner1187563wantoner
welcomer1544023welcomer

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.423422437.4
2DLD Change Limit146162956.82621412.5
3Display Results95950.0462065.2
 (SQL Overall)178691957.29524495.0
 
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.