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

79 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
ahead9681705(None) 
ahed89536251ahe_d
head87137171_head
aahed917816442aahe_d
abeam9316532abeam
abed79734132abe_d
aced79540882ace_d
ached119227832ache_d
afeard1058262afeard
aged67334252age_d
aha611246642ah_a_
ahem97225362ahe_m
ahold94714252ahold
airhead1136992airhead
amend85717752amend
anear55420322anear
apeak115513452apeak
aped78538152ape_d
area45843392area_
areae55229742areae
areal55928732areal
areas55935772areas
asea46327182asea_
ashed97829772ashe_d
audad71511392audad
awed88436032awe_d
axed128829612axe_d
bead75937922_bead
behead1239922behead
bread85523112bread
cathead1338752cathead
chad105525502ch_ad
cheap126915942cheap
cheat105732452cheat
cohead123811122cohead
dead65434242_dead
dread74419022dread
fathead1437862fathead
had77658762_h_ad
haed86338582hae_d
heads95127112_heads
heady125117262_heady
heal75645692_heal
heap96432892_heap
hear76143882_hear
heard95222752_heard
heat77061422_heat
heed86437602_heed
held85330402_held
herd84933062_herd
hexad164910622_hexad
jarhead1835172jarhead
jehad1637682jehad
kheda1346532kheda
knead10429662knead
lead56038852_lead
mead75531602_mead
ohed87825182ohe_d
oread64619602oread
plead85818462plead
read55942532_read
rhea75017432rhea_
rheas84816952rheas
saphead1357772saphead
shad86230912sh_ad
shea76031572shea_
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
shed86536152she_d
shend94719972shend
sherd96321152sherd
stead65520272stead
thread105011092thread
tread64821702tread
warhead1436602warhead
wheal115716182wheal
wheat114924572wheat

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit53800791.70331591.3
3Display Results79790.0164937.5
 (SQL Overall)178691792.03287938.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.