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 “hunter” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 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
hunter9481777(None) 
bunter85020381bunter
chunter123911481chunter
haunter103111151haunter
hinter94021301hinter
hunger104015201hunger
hunker133917671hunker
hunted104417011hunted
hunters103915731hunters
hurter93915851hurter
punter84320021punter
shunter103611731shunter
banter84825332banter
blunter94512032blunter
bunker124519372bunker
bunted95219182bunted
bunters94717122bunters
buster84726492buster
butter84724232butter
canter85230112canter
center84421412center
chanter123919732chanter
chaunter1366392chaunter
chunters133910902chunters
counter94220152counter
cunner83915002cunner
curter85320082curter
cuter74728232cu_ter
cutter84521002cutter
daunter83811752daunter
dunker113616462dunker
dunner73913822dunner
dunted84718502dunted
duster74919722duster
enter54726382_enter
funder104016082funder
funker133915762funker
funner93414102funner
gaunter82910712gaunter
grunter83110782grunter
gunner73813982gunner
gutter73817712gutter
hafter124815882hafter
halter94420882halter
hander104526432hander
hanger104023252hanger
hanker134622092hanker
hanted104124312hanted
hater85034752h_ater
hatter94724872hatter
haunted11399732haunted
haunters11329542haunters
heater94828302heater
hefter124313922hefter
hented104218752hented
hinder104120062hinder
hinger104723332hinger
hinted104318322hinted
hinters103719582hinters
hitter94419862hitter
honer85332092hon_er
honker134117462honker
hooter94123932hooter
hotter94720082hotter
hounder113412232hounder
huger94914872hu_ger
hugger114713122hugger
huller93919102huller
hummer133615272hummer
humper134115882humper
hungers114013302hungers
hunkers143314332hunkers
hunkey164210882hunkey
hunkier144512142hunkier
hunt76445492hunt__
hunts86826172hunt_s
hurler94717222hurler
hurters103413642hurters
husker134212702husker
hustler103410752hustler
hutted104616332hutted
inter55028492_inter
junker174213652junker
juster134617012juster
linter64625342linter
lunger75720422lunger
lunier64617602lunier
lunker104718342lunker
lunted74517522lunted
luster64023672luster
minter84425102minter
mounter93713172mounter
munster93710522munster
muster84724522muster
muter74525542mu_ter
mutter84418882mutter
nutter63918052nutter
ouster64223732ouster
outer55633302ou_ter
punier84519222punier
punker123718822punker
punner84918152punner
punster92911102punster
punted94618712punted
punters93617042punters
putter83921442putter
quoter153510092quoter
ranter63826822ranter
renter64527412renter
runner63814462runner
runtier73512852runtier
saunter72913452saunter
shunner10358642shunner
shunted11339782shunted
shunters113210752shunters
shutter103712142shutter
sinter63625922sinter
suiter64121812suiter
sunder74019822sunder
taunter73111452taunter
tenter64623932tenter
thunder1136962thunder
tinter63923642tinter
tufter9319932tufter
tuner56022682tun_er
under64624212_under
uniter64619142_uniter
utter54218762_utter
vaunter10309602vaunter
venter94218722venter
wanter94423052wanter
winter94222802winter

Search took 3 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 Filter178691825510.330541487.9
2DLD Change Limit825511322.12338884.1
3Display Results1321320.0304400.0
 (SQL Overall)1786911322.48371965.8
 
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.