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

122 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
huntress114483(None) 
buttress1035882buttress
hundreds1344002hundreds
hunters103915732hunt_ers
huntresses1345282huntresses
hurtless11307782hurtless
sundress936982sundress
undress838892_undress
unstress837372_unstress
untruss736552_untruss
actress948533_actress
adultress1042943adultress
ancress978613_ancress
antres65021003_antre_s
aunties73920073auntie_s
bluntness1144343bluntness
bunters94717123bunt_ers
centres93817123centre_s
chunters133910903chunt_ers
congress1138073congress
countess103710053count_ess
countless1146373countless
curtness1037263curtness
dauntless1033663dauntless
distress9311713distress
ductless11196313ductless
dunness8298983dun_ness
duress74712063du__ress
dustless9328353dustless
editress944933editress
entrees71813773_entrees
fortress1136753fortress
gauntness1044203gauntness
gumtrees1143883gumtrees
gunless8299633gun_less
gustless9287683gustless
gutless82610713gu_tless
haltless11308443haltless
handless123512063handless
handpress1544033handpress
hantles104117513hantle_s
hatless103813443h_atless
hatreds11307813h_atreds
haunters11329543haunt_ers
heatless113011463heatless
heiress1036813h_eiress
hiltless11297123hiltless
hinters103719583hint_ers
hitless103211193h_itless
honorees1148773honorees
honorers1139263honorers
hostess103210243host_ess
hotness1038613h_otness
hotpress1344303hotpress
hueless1058823hu_eless
hugeness1237373hugeness
humorless1442963humorless
humpless15226333humpless
hunches153913463hunche_s
hundred1237143hundre_d
hungers114013303hun_gers
hungriest1344543hungriest
hungriness1443173hungriness
hunkers143314333hun_kers
hunkeys17386193hun_keys
hunkies143214503hunkie_s
hunkiest153812333hunkiest
hunted104417013hunt_e_d
hunter94817773hunt_e_r
huntings12328053huntings
hunts86826173hunt___s
hurters103413643hurt_ers
hurtles103913753hurtle_s
hustlers11349203hustlers
hustles103414173hustle_s
ingress838653_ingress
jointress1643053jointress
justness1535323justness
laundress1042813laundress
lintless82710013lintless
lustres73013233lustre_s
mattress1036533mattress
mistress10310703mistress
oratress834553oratress
outdress9137323outdress
outpress10118183outpress
pantdress1243363pantdress
portress1038323portress
puniness101610273puniness
punters93617043punt_ers
punties94520783puntie_s
quatres163411933quatre_s
restress82511773restress
rungless956733rungless
runless72810423run_less
runtiest83014513runtiest
runtiness92410393runtiness
rustless83510243rustless
shunters113210753shunt_ers
stress66616673__stress
sunless73013693sun_less
suppress1236443suppress
tentless8229843tentless
tintless8239863tintless
tress55423163___tress
tuneless837913tuneless
tutoress845093tutoress
uncross938193_uncross
undrest8313013_undrest
unfrees1048643_unfrees
unless62413073_un_less
unrest62918853_un_rest
unrests7229463_un_rests
unties64326923_untie_s
untread857413_untread
untreads936223_untreads
untrims938613_untrims
untruest847783_untruest
ventless11249053ventless
victress1344523victress
votress1035483_votress
waitress1135223waitress

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621226.56022280.8
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.02925422.0
 
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.