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

76 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
falconers144532(None) 
falconer1346031falconer_
falconets1444811falconets
almoners1068132_almoners
falconet13410352falcone_t
falconry1642532falcon_ry
falcons1239122falcon__s
alcoves1297873_alcove_s
alieners889823_alieners
aligners9117573_aligners
aliners74717723_al_iners
allovers1137673_allovers
almners9399563_al_mners
almoner949383_almoner_
ancones93116343_ancone_s
atoners75013953_a_toners
balconies1347743balconies
ballonets1146723ballonets
balloters1157673balloters
baloneys1334663bal_oneys
blazoners2043863blazoners
calcaneus1344163calcaneus
calcines12314753calcine_s
caloyers1337343cal_oyers
calzones1948763calzone_s
cloners94514823_cl_oners
facers115519443fa_c__ers
fagoters1234863fa_goters
falces115216003falc__e_s
falcon11310293falcon___
falconine1445173falconine
falconoid1553153falconoid
falconries1543953falconries
fallers103917993fal__lers
fallowness1642943fallowness
falseness1236093falseness
falterers12238033falterers
falters103916473fal__ters
fanciers13358083fanc_iers
fanciness1437673fanciness
fanners103914653fa__nners
farcers124713443farc__ers
fascines13310143fascine_s
fashioners16123963fashioners
fasteners12237053fasteners
fathomers1744953fathomers
fatteners12236873fatteners
favorers1465493fa_vorers
fawners13388493fa__wners
filchers16286863filc_hers
flacons1238053flacon__s
flavones1435833flavone_s
flavorers1563983flavorers
flooders12257833f_looders
floorers11227573f_loorers
flowers133413173f_l_owers
flyovers1733673f_lyovers
followers15146183followers
gallopers12136323gallopers
gammoners1444563gammoners
hallowers15137723hallowers
jaconets1745613ja_conets
jawboners21133053jawboners
larceners1135993larceners
loners64225813__l_oners
maligners12104783maligners
parceners1337453parceners
pardoners12208213pardoners
ratooners965833ratooners
waggoners1443183waggoners
wagoners1235473wa_goners
walkovers1942613walkovers
wallopers14136273wallopers
wallowers15127653wallowers
wantoners12116673wantoners
welcomers1643513welcomers

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 Filter1786911486410.420425454.8
2DLD Change Limit148641766.28323657.6
3Display Results76760.0302533.3
 (SQL Overall)178691766.73326539.6
 
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.