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

129 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
hematal123895(None) 
haematal1345141haematal
bemata10411692bemata_
hemal104419802hem__al
hematic141816742hematic
hematin121516022hematin
hiatal9310202h_iatal
meatal84114732me_atal
amatol838693_amatol
bemadam1445773bemadam
bimetal1138433bimetal
cental84420963ce_ntal
ceramal1138843ceramal
chemical1748393chemical
climatal1244403climatal
decadal1137243decadal
decanal1038113decanal
dental74319173de_ntal
edemata1046003edemata_
email74715103_ema_il
enemata948013enemata_
fatal84819373__fatal
femoral1238723femoral
fermata12278143fermata_
fermatas13246223fermatas
festal94213563fe_stal
fetal85623373fe__tal
gametal1037603gametal
geminal10109903geminal
genital849793genital
hadal95518123h__adal
haemal113811643haem__al
haematic151310213haematic
haematin13148893haematin
halal85623593h__alal
hamada1239923hamada_
hamadas1339673hamadas
hamal104623113h__amal
hamate113319833hamat_e
hamates122917683hamates
hamaul114210873hama_ul
hammal134512063ham_mal
hartal9415473h_artal
heal75645693he___al
heat77061423he_at__
heatable131612043he_atable
heated104525593he_ated
heater94828303he_ater
heath115724283he_at_h
heaths126316383he_aths
heathy156111213he_athy
heats85838403he_at_s
heeltap1243723heeltap
heliacal1344723heliacal
helical12311153helical
hemagog1444073hemagog
hematein1387013hematein
hematics151712193hematics
hematine131614673hematine
hematins131714673hematins
hematite131612153hematite
hematoid1449753hematoid
hematoma1545693hematoma
hematomas1645463hematomas
hemiacetal1752103hemiacetal
hemiola12107003hemiola
hemostat1348693hemostat
hepatic141712773hepatic
heptad1237273he_ptad
herbal112513493he_rbal
hermaean1343603hermaean
hernial10310433hernial
hexapla1943343hexapla
hiemal11339503hiem__al
himatia1248593himatia
humate113214443humat_e
humates122813193humates
humeral1238563humeral
humoral1237973humoral
hyetal1236543h_yetal
hymenal1545183hymenal
hymnal1434913hym_nal
jemadar1743373jemadar
lemmata1144673lemmata_
mental84521603me_ntal
metal75427383__metal
metatag1045053metatag
natal53921493__natal
nematic111713993nematic
neonatal844383neonatal
omental93210413omental
palatal9310153palatal
petal76526893pe__tal
prenatal1048373prenatal
primatal1247133primatal
ratal55025113__ratal
reata54225393re_ata_
reatas64021013re_atas
recital9412163recital
rectal84418133re_ctal
refutal1046943refutal
regmata1036193regmata_
remail85017123rema_il
rematch1436193rematch
remate84428683remat_e
remated103522473remated
remates93827113remates
remittal1046513remittal
remnantal1142533remnantal
removal1236733removal
rental63922023re_ntal
retotal739843retotal
rhematic15188923rhematic
schemata1545003schemata_
segetal868383segetal
sematic111716873sematic
seminal91213403seminal
septal84513383se_ptal
setal56430903se__tal
somata8312383somata_
somital939403somital
statal61613223_statal
stomatal1045833stomatal
stratal72710603stratal
tectal83713253te_ctal
tetanal738023tetanal
thematic152011483thematic
vegetal1156303vegetal
vestal94615573ve_stal

Search took 7 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 Limit1340271296.06322105.7
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.26528522.1
 
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.