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

108 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
hunters10391573(None) 
bunters94717121bunters
chunters133910901chunters
haunters11329541haunters
hinters103719581hinters
hungers114013301hungers
hunkers143314331hunkers
hunter94817771hunter_
hurters103413641hurters
punters93617041punters
shunters113210751shunters
banters94623112banters
bunkers133715952bunkers
bunter85020382bunter_
busters94724132busters
butters94521722butters
canters94827732canters
centers94420602centers
chanters134016742chanters
chaunters1455822chaunters
chunter123911482chunter_
counters103320192counters
cunners93913472cunners
cutters94218962cutters
daunters9329852daunters
dunkers123512192dunkers
dusters84918362dusters
enters64425642_enters
funders113813932funders
funkers143712062funkers
grunters9359032grunters
gunners83111732gunners
gutters83715512gutters
hafters134614332hafters
halters104619802halters
handers114224332handers
hangers113120812hangers
hankers144218132hankers
haters94930402h_aters
hatters104221522hatters
haunter103111152haunter_
heaters104225222heaters
hefters134312002hefters
hinders113718502hinders
hingers113420212hingers
hinter94021302hinter_
hitters104717592hitters
honers94324972hon_ers
honkers143315232honkers
hooters104520472hooters
hounders123111712hounders
huggers124211592huggers
hullers103616262hullers
hummers143813062hummers
humpers142713522humpers
hunger104015202hunger_
hunker133917672hunker_
hunkeys17386192hunkeys
hunted104417012hunte_d
huntress1144832huntress
hunts86826172hunt__s
hurlers103714322hurlers
hurter93915852hurter_
huskers143510042huskers
hustlers11349202hustlers
inters64328052_inters
junkers184010862junkers
justers143815732justers
linters73822632linters
lungers83817092lungers
lunkers113414602lunkers
lusters73921442lusters
minters93822472minters
mounters103712502mounters
munsters104010552munsters
musters94522512musters
mutters94117142mutters
nutters74215432nutters
ousters74122792ousters
outers64230172ou_ters
punkers133714852punkers
punners94114232punners
punsters103310582punsters
punter84320022punter_
putters94219192putters
quoters16369262quoters
ranters73323642ranters
renters74224812renters
runners74212452runners
saunters82911752saunters
shunners11317742shunners
shunter103611732shunter_
shutters113611352shutters
sinters74024082sinters
suiters73618882suiters
sunders84120052sunders
taunters8259272taunters
tenters73921102tenters
thunders1236952thunders
tinters74221112tinters
tufters10298352tufters
tuners64417342tun_ers
uniters73814172_uniters
utters63817122_utters
vaunters11327752vaunters
venters103717732venters
wanters104420092wanters
winters103720482winters

Search took 4 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 Filter1786911076710.406440125.6
2DLD Change Limit1076711083.39031761.4
3Display Results1081080.0333272.7
 (SQL Overall)1786911083.82946667.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.