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

229 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
hadjees1835638(None) 
hadjee174111821hadjee_
hadjes175210401hadj_es
hackees165014102hackees
hades96035112had__es
hadjis17439652hadj_is
hajes155420942ha_j_es
hajjes15485242ha_jjes
ackees124914573_ackees
adages8412953_adages
adders84315703_adders
addles84216603_addles
adeem8311803_ad_eem
adeems946333_adeems
adheres11310163_adheres
adieus739633_adieus
adjures1536233_adjures
adobes94411533_adobes
adores74420723_adores
adzes155913803_ad_zes
agrees74915323_agrees
ajee115928233_a_jee_
akees96119243_a_kees
allees64521483_allees
baddies114017873baddies
badgers114812653badgers
badges103917363bad_ges
badness1039573badness
bailees93914383bailees
banjoes16317313banjoes
bargees105415873bargees
baubees11348713baubees
bawbees14337243bawbees
caddies113718383caddies
cades85440733cad__es
cadets96316513cad_ets
cadgers114712003cadgers
cadges104716703cad_ges
cadres94017933cad_res
callees94117783callees
chadless1436403chadless
daddies103414943daddies
daddles104213803daddles
dadoes85616533dad_oes
dees56356633__d_ees
drees65628523__drees
faders105117463fad_ers
fades94932863fad__es
fadges114814023fad_ges
fanjets1734803fanjets
gadders103611503gadders
gadgets10348683gadgets
gadje1457743gadj_e_
haceks15447863ha_ceks
hackee154921833hackee_
hackers164619043hackers
hackies163418243hackies
hackles162917063hackles
haddest122711993haddest
hade85440193had__e_
haded105227623had__ed
hadiths1436023hadiths
hadj155818673hadj___
hadji16839893hadj__i
hadrons113314303hadrons
haems105517013ha__ems
haeredes1246333haeredes
haeres94017033ha_eres
haes77651023ha___es
haets86525123ha__ets
haffets1636053haffets
hafizes2235983hafizes
hafters134614333hafters
haggles123312483haggles
hailers104017263hailers
hajis156716283ha_j_is
hajjis15485893ha_jjis
hakeem15407383ha_keem
hakeems16394803hakeems
hakes126034303ha__kes
halers94926913ha_lers
hales85449843ha__les
halides113416663halides
halites103221193halites
hallels103310133hallels
halloes104021523halloes
haloes94623863ha_loes
halteres113414593halteres
halters104619803halters
halvers133311423halvers
halves124717093ha_lves
hamates122917683hamates
hames106138703ha__mes
hamlets123211403hamlets
hammers144216063hammers
hampers143616953hampers
hances115621283ha_nces
handaxes1938403handaxes
handers114224333handers
handlers124014143handlers
handles114020653handles
handless123512063handless
handsels12317243handsels
handsets12258343handsets
hangers113120813hangers
hankers144218133hankers
hankies143617763hankies
hansels104011653hansels
hanses95022633ha_nses
hantles104117513hantles
haoles94919803ha_oles
hapaxes1936593hapaxes
hapless123311333hapless
happens14359173happens
haptenes133810823haptenes
haptens124511343haptens
hardens113815023hardens
hardies114923233hardies
hardness122411083hardness
hareem114312063ha_reem
hareems12428203hareems
harems115513823ha_rems
hares86255543ha__res
harkens144112863harkens
harmers124116593harmers
harness102413933harness
harpers124916203harpers
harpies123818313harpies
harries103525493harries
hasheesh1342593hasheesh
hashes125024803ha_shes
haslets102510863haslets
hassels104311013hassels
hassles103411693hassles
hastens106214813hastens
hastes95727073ha_stes
hatches153420273hatches
haters94930403ha_ters
hates86742573ha__tes
hatless103813443hatless
hatreds11307813hatreds
hatters104221523hatters
haulers104012443haulers
hausens1077633hausens
havens124514043ha_vens
havers124721483ha_vers
haves116034873ha__ves
hawkers174210333hawkers
hawkeys20414703hawkeys
hawkies173311243hawkies
hawsers13409483hawsers
hawses125113993ha_wses
hayers124415943ha_yers
hayseed1435633hayseed
hayseeds1543283hayseeds
hazels185710083ha_zels
hazers184615953ha_zers
hazes174928323ha__zes
headers113819393head_ers
headless12289863headless
headsets1236053headsets
heddles123311623heddles
heders104119763hed_ers
hedgers124310253hedgers
hedges115016243hed_ges
hiders104919653hid_ers
hides95129423hid__es
hirees95117293h_irees
hoddens12378803hoddens
huddles123712573huddles
humvees1534683humvees
jades135222113jad__es
jaygees1854513jaygees
jayvees2052923jayvees
jees115938543___jees
ladders94115173ladders
laddies93715053laddies
ladens74516233lad_ens
laders74927763lad_ers
lades65141273lad__es
ladies75124883lad_ies
ladlers84613563ladlers
ladles74619543lad_les
larees65323113la_rees
madames12310063madames
maddens11359753maddens
madders113513213madders
madness10310073madness
madres93718183mad_res
mallees93315973mallees
mammees104411143mammees
padders113312873padders
paddies113715723paddies
paddles113515643paddles
padles95221123pad_les
padres95016983pad_res
pawnees12298173pawnees
payees114812903pa_yees
raddles93615703raddles
radices102314263radices
radixes15259343radixes
radomes10311053radomes
ragees74618663ra_gees
raggees93710913raggees
rajes125022783ra_j_es
rakees104516973ra_kees
ramees84620893ra_mees
ramjets1635163ramjets
ranees64623963ra_nees
rappees113611453rappees
razees154314763ra_zees
saddens9309603saddens
saddles95415743saddles
sades65239893sad__es
sadhes104715373sad_hes
sadness8310613sadness
sarees65329943sa_rees
shaders115915553shad_ers
shades105924533shad__es
tajes124920693ta_j_es
wadders123812443wadders
waddies124214753waddies
waddles124314843waddles
waders109120643wad_ers
wades95634143wad__es
wadies105121203wad_ies
wadmels1334303wadmels
wadsets1136443wadsets
whangees15275063whangees

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272297.03019065.0
3Display Results2292290.0802862.5
 (SQL Overall)1786912297.26624592.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.