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

129 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
fanfare133667(None) 
fanfares1436771fanfares
carfare12310072carfare
fanfaron1493632fanfaron
infare9313082_infare
warfare1336732warfare
afar76720783_a_far_
afars85716513_a_fars
affaire1344463_affaire
afire86215913_a_fire
afore85818603_a_fore
aglare7312423_aglare
airfare1047243airfare
anear55420323_anear_
aneared8512743_aneared
anears63717183_anears
angary10311323_angary
anlace82513923_anlace
anlage72514233_anlage
ansae55720973_ansa_e
ansate64517863_ansate
antae56828293_anta_e
antre55224523_an_tre
aware86420023_a_ware
bandage11311023bandage
bandore10611633bandore
barware12610703barware
bonfire1287063bonfire
canape10913513can_ape
canard9314763can_ard
canary11314693can_ary
caneware1347803caneware
carfares13310323carfares
catface1436763catface
caviare1238373caviare
centare93113703centare
daycare1355093daycare
daymare1375633daymare
enface112510353_enface
facade1238803fa_cade
faciae112913413facia_e
facture12108923facture
failure1035753failure
falcate12311613falcate
fancier123412063fancier
fane75343573fan___e
fanfarons1573623fanfarons
fanfic1436313fanf_ic
fanfics1535173fanfics
fanfold1485373fanfold
fanga96119623fanga__
fangas105017193fanga_s
fanlike142610503fanlike
fanner94218183fanner_
fanners103914653fanners
fantail10310233fantail
fantasie11117743fantasie
fantasm1236593fantasm
fantast10311703fantast
fantasy1336153fantasy
fanwise1336633fanwise
fanwort13310733fanwort
fanzine1937123fanzine
fare76354463___fare
farfal123410183farfa_l
farfalle1445063farfalle
farfals13268503farfals
faunae95210373fauna_e
finale94116763fin_ale
finmark16154883finmark
flancard1443373flancard
flare84823633f__lare
flatware1444883flatware
forbare122310513forbare
foxfire2042563foxfire
funfair1342033funfair
funfairs1442133funfairs
gunfire1134743gunfire
hangar104114513hangar_
hangared1337573hangared
hangars114313493hangars
hangfire1543763hangfire
infares10313023_infares
kantar10311153kantar_
kantars11310033kantars
lanate6421263lan_ate
laniard868523laniard
laniary1068013laniary
lanyard1167293lanyard
manage93818903man_age
mandate10315573mandate
manmade1237963manmade
mansard1049313mansard
manuary1237773manuary
manure8313653man_ure
manward1349093manward
nonfarm1246513nonfarm
pancake1536673pancake
pandore10411853pandore
panfry14456413panf_ry
safari91110223sa_fari
sangar73617683sangar_
sangaree949333sangaree
sangars83116253sangars
sansar63613393sansar_
sansars73313913sansars
snare54429983_sn_are
taffarel1442563taffarel
tanbark1337373tanbark
tankage12257773tankage
tankard1267263tankard
tannage8209583tannage
tannate71813523tannate
tantara72410823tantara
tanyard1167183tanyard
tartare73012683tartare
tinware1038603tinware
unaware1038033unaware
vantage11109893vantage
vanward1456943vanward
wannabe1234533wannabe
wantage11119623wantage
warfares1436683warfares
wayfarer1742923wayfarer
welfare1335713welfare
zaffar21385043zaffar_
zaffars22325233zaffars
zaffre21354663za_ffre
zingare1737143zingare

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.406440125.6
2DLD Change Limit1340271295.84322938.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.29528386.2
 
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.