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

107 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
fanfares143677(None) 
fanfare1336671fanfare_
carfares13310322carfares
fanfaron1493632fanfaron
fanfarons1573622fanfarons
infares10313022_infares
warfares1436682warfares
afars85716513_a_far_s
affaires1444303_affaires
airfares1146693airfares
aneared8512743_aneared
anears63717183_anear_s
angaries9314393_angaries
anlaces92313733_anlaces
anlages82414113_anlages
anlases72514903_anlases
annates72415423_annates
antres65021003_an_tres
bandages12310633bandages
bandores11311603bandores
banjaxes2443393banjaxes
barwares13610093barwares
bonfires1367383bonfires
canapes111213083can_apes
canards10311203can_ards
canaries10318943can_aries
canewares1447363canewares
canvases13349523canvases
carfare12310073carfare_
catfaces1536963catfaces
caviares1337993caviares
centares102913893centares
daycares1454803daycares
daymares1445333daymares
enfaces122110913_enfaces
facades1339033fa_cades
factures13129023factures
failures1135163failures
fanciers13358083fanciers
fancies124018783fan_cies
fanes84639893fan___es
fanfics1535173fanf_ics
fanfolds15104073fanfolds
fangas105017193fanga__s
fanners103914653fanner_s
fannies103415643fan_nies
fantails1139693fantails
fantasies1298853fantasies
fantasms1345633fantasms
fantasts1147113fantasts
fanworts1446103fanworts
fanzines2036913fanzines
fares85852873___fares
farfals13268503farfa_ls
finales104016013fin_ales
finmarks17154473finmarks
flancards1543183flancards
flares94521703f__lares
flatwares1544763flatwares
foxfires2142813foxfires
funfairs1442133funfairs
furfures1445663furfures
gunfires1235063gunfires
handaxes1938403handaxes
hangared1337573hangared
hangars114313493hangar_s
hangfires1643843hangfires
infare9313083_infare_
kantars11310033kantar_s
laniards967313laniards
laniaries9411213laniaries
lanyards1266393lanyards
manages103418963man_ages
mandates11314093mandates
mansards1148013mansards
manures9313353man_ures
manwards1447613manwards
nares55544153__n_ares
pancakes1637073pancakes
pandores11312453pandores
panfries13149203panfries
safaris101110663sa_faris
sangaree949333sangaree
sangarees1046543sangarees
sangars83116253sangar_s
sansars73313913sansar_s
snares65329033_sn_ares
taffarel1442563taffarel
taffarels1541863taffarels
tanbarks1445563tanbarks
tankages13217113tankages
tankards1366253tankards
tannages9228963tannages
tannates81911953tannates
tantaras8269543tantaras
tanyards1276183tanyards
tinwares1137913tinwares
unawares1137053unawares
vantages12119023vantages
wannabes1344473wannabes
wantages12109023wantages
warfare1336733warfare_
wayfarer1742923wayfarer
wayfarers1842623wayfarers
welfares1445543welfares
zaffars22325233zaffar_s
zaffres22324993za_ffres

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 Limit1461621076.82621412.5
3Display Results1071070.0333242.4
 (SQL Overall)1786911077.28224538.7
 
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.