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

161 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
hangnest1231141(None) 
hangnests1344541hangnests
handiest123417782handiest
mangiest112815902mangiest
rangiest93115982rangiest
tangiest92915222tangiest
tannest72617852tan_nest
wannest103915002wan_nest
anapest9311563_anapest
anenst63514983_anen_st
angles74426703_angles_
angriest9310253_angriest
angst6415493_ang__st
baggiest123011753baggiest
bangles103617413bangles_
bannet84925333ban_ne_t
bannets94013843ban_nets
barghest1447913barghest
barguest1137163barguest
cagiest102916433ca_giest
cangues10611823cangues_
canines93724033canines_
canniest10313363canniest
canoness1039393canoness
canonist10513533canonist
chanciest1638383chanciest
changes134517583chang_es_
congest104618773cong_est
dandiest103415033dandiest
dangles93618423dangles_
dangliest1137173dangliest
dankest122611673dan_kest
dankness13256693dankness
dingiest102915373dingiest
dungiest102810743dungiest
dunnest83312263dun_nest
earnest7318733ea_rnest
faggiest132910183faggiest
fainest10417703fa_inest
fanciest133612713fanciest
fangless1237663fangless
funnest102912003fun_nest
gangliest1137673gangliest
gangues9149753gangues_
gannet74321853gan_ne_t
gannets83811443gan_nets
haddest122711993ha_ddest
haggles123312483haggles_
hairiest11612473hairiest
hairnet10911703hairne_t
hairnets1195633hairnets
haleness11312623haleness
halest94823273ha__lest
halfness1435563halfness
hammiest152610013hammiest
hances115621283han_ces_
handfast1546733handfast
handiness132110933handiness
handles114020653handles_
handless123512063handless
handlist12311333handlist
handset113016823handse_t
handsets12258343handsets
hangars114313493hangars_
hanged114222393hang_e_d
hanger104023253hang_e_r
hangers113120813hang_ers
hangings13258583hangings_
hangmen1337383hangme_n
hangnail1253663hangnail
hangout11411393hang_out
hangouts1236183hangouts
hangs95726723hang__s_
hangups1364813hangups_
hankies143617763hankies_
hanses95022633han_ses_
hantles104117513hantles_
happiest152411683happiest
hardest113118413ha_rdest
hardiest123416343hardiest
hardness122411083hardness
harness102413933ha_rness
harshest14310193harshest
harvest132112753ha_rvest
hastiest112916503hastiest
haziest193313013ha_ziest
haziness20248513haziness
hedgiest13298133hedgiest
henges104516463heng_es_
highest1439563h_ighest
hinges105121033hing_es_
hinkiest153311753hinkiest
honest94822423h__onest
hongies112716473hongies_
hugest10311763h_ug_est
humanest1348123humanest
hungriest1344543hungriest
hunkiest153812333hunkiest
inanest72115363_inanest
ingest73119003_ing_est
jaggiest17289323jaggiest
jangles154015683jangles_
jangliest1746383jangliest
langues81211913langues_
languet8713693langue_t
languets987243languets
lankest112714113lan_kest
lankiest122912503lankiest
lankness12237043lankness
largest83715103larg_est
lingiest93715263lingiest
longest84114953long_est
longness938553longness
magnet9320663ma_gne_t
magnets10311143ma_gnets
manganese1244803manganese
manges94628943mang_es_
manginess122010413manginess
mangles104021463mangles_
mangoes104316133mangoes_
manifest1339503manifest
manliest102314943manliest
mingiest113315823mingiest
naggiest102610013naggiest
nonguest938563nonguest
orangiest1038463orangiest
pangenes112612823pangenes_
pangens103112063pangens_
pannes85522853pan_nes_
randiest93418773randiest
ranges73826923rang_es_
ranginess101610213ranginess
rankest112713813ran_kest
rankness12267943rankness
sagest74920263sa_g_est
saggiest102812723saggiest
sagiest82617993sa_giest
sandiest93218693sandiest
saneness82313723saneness
sanest64426693sa__nest
shaggiest14156903shaggiest
slangiest10129083slangiest
songfest1236843songfest
tangent8314993tang_ent
tangents938713tangents
tanginess10239283tanginess
tangles83920043tangles_
tangliest1068423tangliest
thingness1354893thingness
thinnest11248893thin_nest
twangiest1355223twangiest
vaguest1137333va_guest
vainest10315763va_inest
wangles113416933wangles_
waniest103819113wan_iest
wanness102610683wan_ness
whangees15275063whangees_
wingiest123214283wingiest
zaniest163214773zan_iest
zaniness1738663zaniness
zingiest182810893zingiest

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.436409841.7
2DLD Change Limit1461621617.22020244.0
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.71923149.5
 
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.