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

152 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
hagbut127892(None) 
hagbuts1354931hagbuts
sagbut959751sagbut
abut66834952_a_but
barbut104617002barbut
habit103027022ha_bit
habu97325482ha_bu_
habus106317142ha_bus
hackbut1845712hackbut
hagbush1642622hagbush
halibut1289052halibut
hangout11411392hangout
haut75949732ha__ut
hognut1039412hognut
ragout7317182ragout
sacbut10811942sacbut
sagbuts1065222sagbuts
abbot9318453_abbot
abet610547943_a_bet
about75229083_about
abuts75417073_a_buts
agent65829643_agent
agist66325583_agist
aglet65534143_aglet
agouti7388773_agouti
agouty10366913_agouty
ague55725923_ag_ue
album92312653_album
ambit94223713_ambit
arbute8311043_arbute
babu85829233ba_bu_
babul96317713ba_bul
babus95620333ba_bus
bagful1237213bagful
baguet9316103baguet
barbet104427883barbet
barbuts11439843barbuts
bugout9311863bugout
but55963023___but
caput9823983ca_put
catgut9310803catgut
chabuk1734673cha_buk
daut56443563da__ut
debut86024143_debut
dugout8310363dugout
eaglet73722583eaglet
earbud936283earbud
englut738453englut
faggot1139053faggot
fagot9323403fag_ot
gambit114714213gambit
gamut8322983ga_mut
ghaut95919433gha__ut
glut56331293__glut
gout56646003__gout
gut46753853__g_ut
habits113014653ha_bits
hackbuts1943873hackbuts
hadst93220223ha_dst
haet75659503ha__et
haffet15311703haffet
haffit1538533haffit
haft105941843ha__ft
hag77255743hag___
hagborn1344953hagborn
hagdon1188283hagdon
hagged124317703hagged
haggis11209513haggis
haggle113511983haggle
hags86740843hag__s
haiku126113693haiku_
haikus13538293haikus
haint85436323ha_int
haircut1246833haircut
haku116923893ha_ku_
hakus125114113ha_kus
halbert12314503halbert
halest94823273halest
halibuts1364443halibuts
hallot95426783hallot
hallux1637363hallux
halt76056303ha__lt
halutz1868853ha_lutz
hamaul114210873hamaul
hamburg1544133hamburg
hamlet113722793hamlet
handout11314103handout
hangouts1236183hangouts
hangul1049223hangul
hangup1277303hangup
hant75461593ha__nt
harbor11410723harbor
harbour1247053harbour
harlot94422803harlot
hart76865773ha__rt
haslet93222713haslet
hast76259483ha__st
hat67289963ha___t
hatbox1835133hatbox
hatful12108743hatful
haul75530453ha__ul
haunt85229133ha_unt
haute89521613ha__ute
hazmat20312263hazmat
henbit111412003henbit
hight125327233hig_ht
hobbit132810543hobbit
hogget114715763hogget
hognuts1134183hognuts
holibut1297483holibut
hubbub1243603hubbub
hugest10311763hugest
humbug1434803humbug
hut66457293h___ut
iambus10468903iambus
jabot14321513ja_bot
kagu95418113kag_u_
kagus105812033kag_us
kaput11717063ka_put
krubut1245553krubut
layout9513703layout
maggot10311713maggot
magnet9320663magnet
magnum1136733magnum
magot8326393mag_ot
magus85318753mag_us
mahout11415813mahout
maut65448453ma__ut
payout11714653payout
pignut9311573pignut
pigout9314613pigout
rabat72832223ra_bat
rabbet103818653rabbet
rabbit102914563rabbit
ragbag1045463ragbag
ragouts838543ragouts
rebut75927383_rebut
sabbat10314713sabbat
sabot7931783sa_bot
sacbuts1166473sacbuts
sackbut1545943sackbut
sagest74920263sagest
sagum8512873sag_um
sambur10469503sambur
tabu66328493ta_bu_
tabun75914373ta_bun
tabus74820923ta_bus
tambur10358713tambur
taut47048963ta__ut
vague96513113vag_ue
vagus96713813vag_us
walnut939433walnut

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 Filter1786911127160.393454684.5
2DLD Change Limit1127161525.82619347.1
3Display Results1521520.0463304.3
 (SQL Overall)1786911526.26528522.1
 
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.