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

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
hurters10341364(None) 
hunters103915731hunters
hurlers103714321hurlers
hurter93915851hurter_
barters94223032barters
blurters10348372blurters
bunters94717122bunters
burgers103918572burgers
buriers94017192buriers
burkers133716622burkers
burlers94120272burlers
burners94115672burners
burrers93814492burrers
bursters1038982bursters
busters94724132busters
butters94521722butters
carters95327252carters
charters134115582charters
chunters133910902chunters
churners13316892churners
courters103015372courters
curbers115514382curbers
curers84923192cur_ers
curlers94218072curlers
cursers94317162cursers
curter85320082curter_
cutters94218962cutters
darters84017602darters
dusters84918362dusters
furlers104214222furlers
furthers1436492furthers
garters84218232garters
gutters83715512gutters
hafters134614332hafters
halters104619802halters
harmers124116592harmers
harpers124916202harpers
haters94930402h_aters
hatters104221522hatters
haunters11329542haunters
heaters104225222heaters
hefters134312002hefters
herders113914122herders
hinters103719582hinters
hirers94518062hir_ers
hitters104717592hitters
hooters104520482hooters
huggers124211592huggers
hullers103616262hullers
hummers143813062hummers
humpers142713522humpers
hungers114013302hungers
hunkers143314332hunkers
hunter94817772hunter_
hurdlers12337492hurdlers
hurler94717222hurler_
hurleys13407332hurleys
hurriers11358892hurriers
hurtles103913752hurtles
hurtless11307782hurtless
hurts86922822hurt__s
huskers143510042huskers
hustlers11349202hustlers
justers143815732justers
lurers64217492lur_ers
lurkers113910082lurkers
lusters73921442lusters
murders103311362murders
murthers1336542murthers
musters94522512musters
mutters94117142mutters
nursers74311832nursers
nutters74215432nutters
ousters74122792ousters
outers64230172ou_ters
porters93722702porters
punters93617042punters
purgers104714002purgers
pursers93916092pursers
putters94219192putters
quarters173110452quarters
quoters16369262quoters
shunters113210752shunters
shutters113611352shutters
sorters74221132sorters
spurters103311702spurters
suiters73618882suiters
surfers103614132surfers
surgers83517482surgers
tufters10298352tufters
turners73912892turners
turtlers8258202turtlers
ureters7311822_ureters
urgers73313622_urgers
utters63817122_utters

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.390458182.1
2DLD Change Limit107671953.48330913.3
3Display Results95950.0462065.2
 (SQL Overall)178691953.91945596.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.