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

92 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
hemal10441980(None) 
haemal113811641haemal
hamal104623111hamal
heal75645691he_al
hiemal11339501hiemal
bema85825252bema_
bemas96424282bemas
cecal94619112cecal
comal95125132comal
deal56347412de_al
decal85523232decal
dedal75719022dedal
dermal93614342dermal
domal85619202domal
egal55119432_egal
email74715102_email
feal713940422fe_al
fecal105119212fecal
female11310552female
feral85424652feral
fetal85623372fetal
hadal95518122hadal
halal85623592halal
hamals114816832hamals
hamaul114210872hamaul
hammal134512062hammal
head87137172he_ad
heals85733462he_als
heap96432892he_ap
hear76143882he_ar
heat77061422he_at
heel75034222he_el
heil76328932he_il
hell75637892he_ll
hem86148732hem__
hematal1238952hematal
heme95034412hem_e
hemes105031082hemes
hemic125718622hemic
hemin103620932hemin
hemp115725622hem_p
hemps126917332hemps
hempy154912762hempy
hems95534942hem_s
herald10311342herald
herbal112513492herbal
herl75834552he_rl
herma105318882herma_
hermae115314472hermae
hermai118912862hermai
hetman112510602hetman
hexad164910622hexad
hexyl1844462hexyl
horal86328682horal
human102716032human
hyetal1236542hyetal
hymnal1434912hymnal
leal46043272le_al
legal65715942legal
leman75622602leman
meal65643172me_al
medal86221332medal
metal75427382metal
nema65522522nema_
nemas75321572nemas
peal68648102pe_al
pedal86022502pedal
penal75228372penal
petal76526892petal
ramal74622242ramal
real45750292re_al
regal65023792regal
remail85017122remail
reman75730152reman
remap95418102remap
renal55929502renal
seal45654372se_al
sepal77723002sepal
seral56336382seral
setal56430902setal
sheal84927702she_al
tamal73522622tamal
teal45546502te_al
tepal76319582tepal
thecal113310302thecal
thenal92712422thenal
thermal125010972thermal
veal76936812ve_al
venal85523212venal
weal75838682we_al
wheal115716182whe_al
zeal135530332ze_al

Search took 5 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.623286823.4
2DLD Change Limit53800923.53315227.9
3Display Results92920.0462000.0
 (SQL Overall)178691924.20242525.2
 
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.