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

167 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
flannels113484(None) 
flannel1035421flannel_
cannels93413362_cannels
channels13388492channels
fanners103914652f_anners
fennels10387902f_ennels
flanes94522422fla_ne_s
flangers123311372flangers
flanges113413272flange_s
flankers15349302flankers
flanneled1343312flanneled
flannelet1245252flannelet
flannelets1342452flannelets
flannelly1542652flannelly
flatness1138152flatness
funnels10348172f_unnels
lanners73618332_lanners
planners10399932planners
alanines8314803alanine_s
alanyls1084353ala_nyls
angels74416173__angels
annals66415923__annals
anneals7449943__anneals
annuls64711733__annuls
banners94018713_banners
bannets94013843_bannets
blandness1235973blandness
blankets14356503blankets
blankness1544673blankness
blarneys13183193blarneys
branners104010923branners
cancels114113313_cancels
cannel84216403_cannel_
canners93822663_canners
chancels15439083chancels
channel123910483channel_
charnels13328173charnels
chunnels13304553chunnels
clangers114312343clangers
cleanness1144973cleanness
darnels83710433_darnels
evangels1243733evangels
falafels1453113falafels
fanes84639893f_a_ne_s
fanjets1734803f_anjets
fanned104117473f_anne_d
fanner94218183f_anne_r
fannies103415643f_annies
fardels11389893f_ardels
farfels13348213f_arfels
farness102912203f_arness
fatness103311293f_atness
fawners13388493f_awners
felafels1452853fela_fels
fennecs12305693f_ennecs
fennel9429473f_ennel_
fiancees1335103fiancees
fiances12310673fiance_s
flaggers13328073flaggers
flagless1235403flagless
flails94313003fla__ils
flakers143613273fla_kers
flakes134118873fla_ke_s
flakiness1636473flakiness
flambes14419503flambe_s
flamens124611063fla_mens
flamers124616363fla_mers
flames114723693fla_me_s
flamines13311643flamine_s
flaneur1034183fla_neur
flaneurs1133953flaneurs
flange103411973flange__
flanged123810843flange_d
flanger113412623flange_r
flanked153710643flanke_d
flanken14226763flanke_n
flanker143911293flanke_r
flanks133913403fla_n_ks
flanneling1443813flanneling
flannelled1442843flannelled
flans85327973fla_n__s
flapless1335343flapless
flappers15388383flappers
flares94521703fla_re_s
flashers143912653flashers
flashes133916103flashe_s
flaskets1534603flaskets
flatbeds14364543flatbeds
flatlets1147373flatlets
flattens11357483flattens
flatters113814203flatters
flaunters1234513flaunters
flaunts1056133flaun_ts
flavanols1542203flavanols
flavines1437893flavine_s
flavones1435833flavone_s
flavonols1542183flavonols
flawless1434503flawless
flaxes165015353fla_xe_s
flayers133912033fla_yers
flensers1135463flensers
flenses1039473flense_s
flinders12439263flinders
flingers123410193flingers
floatels11295663floatels
flunkers15347533flunkers
flunkeys18263173flunkeys
frankers15348353frankers
frankness1655223frankness
fresnels1135233fresnels
funnel93610743f_unnel_
gannets83811443_gannets
gladness1036153gladness
glancers11408003glancers
glances104113143glance_s
glanders103811503glanders
glandes95413833glande_s
grapnels1134393grapnels
gunnels8358563_gunnels
hansels104011653_hansels
joannes1436243joanne_s
kennels11387193_kennels
labels84515683_la_bels
lancers93616643_lancers
lances84824103_lance_s
lancets93411163_lancets
landers84026213_landers
lanely93914483_la_nely
lanes54946793_la_ne_s
langrels9106173_langrels
lankness12237043_lankness
lanner64920603_lanne_r
lapels83712043_la_pels
laurels746663_laurels
laxness1436043_laxness
leanness837373leanness
linnets739833_linnets
lintels73311163_lintels
mangels103614493_mangels
manners93417833_manners
mantels94515043_mantels
meanness1037183meanness
panels84716523_pa_nels
panners93621273_panners
pannes85522853_panne_s
plainness1155183plainness
planeness1138153planeness
planers94517943pla_ners
planes85028083pla_ne_s
planets93914083pla_nets
planless1036813planless
planned103810153planne_d
planner93511623planne_r
planters102915323planters
ronnels7318613_ronnels
runnels7329153_runnels
scanners10379703scanners
scrannels1143513scrannels
slanders94014013slanders
spancels1245273spancels
spaniels1045963spaniels
spanners103710773spanners
tanners74018393_tanners
trunnels844513trunnels
tunnels7328723_tunnels
vanners103612843_vanners
wanness102610683_wanness

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 Limit1461621676.82621412.5
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.31224438.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.