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 “hatband” 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
hatband134682(None) 
hatbands1446291hatbands
hairband1444572hairband
headband1544842headband
husband1345652husband
aland65526413_a_land
armband1265983armband
atman75520143_atman_
atmans84413963_atmans
attend7258973_attend
badland1147653badland
band76740913___band
batman105214063batman_
cabana103913563ca_bana
catbird1235243catbird
catjang1733923catjang
cutbank1545533cutbank
databank1542643databank
disband1138243disband
fahlband1742643fahlband
fatback1836923fatback
fatbird1344033fatbird
flatland1264963flatland
gabbard1336553gabbard
garland948703garland
haggard13377183haggard
hairbands1544063hairbands
halberd1336053halberd
halyard1476973halyard
hambone1439313hambone
hamboned1637003hamboned
hand86833713h___and
hariana10310243hariana
hatable121713963hatable
hatbox1835133hatb_ox
hatched163414463hatched
hated95734023hat__ed
hating104929713hat_ing
hatpin112610613hatpin_
hatpins123410643hatpins
hatrack1638213hatrack
hatred104814333hat_red
hatted104921513hat_ted
hatting113920233hatting
hayward1736413hayward
hazan173813613ha_zan_
hazans183411653ha_zans
hazard1938403ha_zard
hazzan17236803hazzan_
hazzans18215783hazzans
headbands1644343headbands
headland1345613headland
heartland1343653heartland
heathland1643963heathland
henbane1237353henbane
hetman112510603hetman_
hetmans12187593hetmans
hitman112710223hitman_
holland11349473holland
hotbed123310683hotb_ed
husbands1444763husbands
kanban1238623kanban_
kanbans1337723kanbans
lalland83810183lalland
natant6318733nat_ant
outland81212343outland
passband1344773passband
proband122710243proband
rainband1144663rainband
ratan53722663rat_an_
ratans63819373rat_ans
ratany93411873rat_any
ratbag956563ratba_g
ratbags1035763ratbags
ratsbane10184343ratsbane
rattan63613603rattan_
rattans73411953rattans
rhatany1353693rhat_any
riband9239623_riband
ribband1245583ribband
roband92310723_roband
sambaed1238303sambaed
saraband1146193saraband
satang75711563sat_ang
shetland1244633shetland
stand65923283_st_and
strand74514823_strand
sweatband1542073sweatband
tabanid1047333ta_banid
tabard9313333ta_bard
waistband1542243waistband
watchband2043223watchband
waveband1743443waveband
wetland1135353wetland
wheatland1641953wheatland

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 Limit134027955.86022871.5
3Display Results95950.0303166.7
 (SQL Overall)178691956.29628381.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.