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

309 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
hadith1331206(None) 
hadiths1436021hadiths
adit56443652_adit_
adits66523712_adits
baith108023132ba_ith
faith115620852fa_ith
habit103027022habit_
habits113014652habits
hading113922942hading
hadst93220222hadst_
halite93624232halite
hath105933912ha__th
jadish17319902jadish
laith85722102la_ith
radish103516912radish
saith85826552sa_ith
adieu6417423_adieu
adios65822863_adios
admit8319493_admit_
admits9411413_admits
adyta936853_adyta
agita6315423_agita
airth85621023_airth
ait38093903_a_it_
aitch105216163_a_itch
aits46355533_a_its
alit46155693_alit_
amity10416093_amity
apish105116633_apish
audit62527883audit_
audits72814113audits
axite125218253_axite
azoth17389903_azoth
bait66556003ba_it_
baits76630583ba_its
baldish1339503baldish
bandit93821133bandit_
bandito103710043bandito
bandits103814793bandits
banish111416043banish
barite84224813barite
bath95940083ba__th
brith104924373_brith
caddish143810133caddish
cadet85339343cadet_
cadets96316513cadets
cadi75732183cadi__
cadis84428503cadi_s
caliph13311403caliph
capita102913773capita
casita82913703casita
cavity14310013cavity
chaloth15298603chaloth
charity15311023charity
chedite1338863chedite
dacite91115883dacite
daleth1038633daleth
danish101513793danish
davit93424593davit_
davits104012363davits
dish86328333__dish
dit47071333__dit_
dita56032523__dita
ditch115015093__ditch
dite55547553__dite
dits56450523__dits
ditz146929513__ditz
doth86225713__doth
dudish1148313dudish
earth85023053ea_rth
eath75735663ea__th
edit54934863_edit_
edits65819033_edits
endite73817593endite
eolith93013903eolith
faddish15359003faddish
fading114821113fading
faiths124610273fa_iths
fajita1635923fajita
famish14311843famish
frith115922033_frith
gadi66329723gadi__
gadid85517383gadi_d
gadids95611823gadids
gadis74825293gadi_s
gait56150193ga_it_
gaits65726013ga_its
garish104516923garish
garth94720223ga_rth
grith95520373_grith
habile11515213habile
habitan1236903habitan
habitat12411053habitat
habited1337883habited
habitue12266703habitue
habitus12338173habitus
had77658763had___
hadal95518123had_al
hade85440193had__e
haded105227623had_ed
hades96035113had_es
hadj155818673had__j
hadjee174111823hadjee
hadjes175210403hadjes
hadji16839893had_ji
hadjis17439653hadjis
hadron102913753hadron
haeing104118923haeing
haet75659503ha_et_
haets86525123ha_ets
haffit1538533haffit_
haffits1636193haffits
hafiz20611213hafi_z
haft105941843ha_ft_
hafts116219463ha_fts
hagfish17227613hagfish
haggish15207473haggish
hah910655223ha___h
haik115526983ha_i_k
haika125313793ha_ika
haiks125120933ha_iks
haiku126113693ha_iku
hail74839063ha_i_l
hails85231643ha_ils
haimish1537753haimish
haint85436323ha_int
haints94417583haints
hair76330143ha_i_r
hairs86225173ha_irs
hairy115316833ha_iry
haji148520193haji__
hajis156716283haji_s
hakim14311833haki_m
hakims1537303hakims
halid94424983hali_d
halide103417993halide
halids104016133halids
haling104229783haling
halites103221193halites
halitus10339963halitus
hallah124115403hallah
halloth134111253halloth
halt76056303ha_lt_
halts85230103ha_lts
halutz1868853halutz
halvah15499833halvah
hamate113319833hamate
hamzah23135563hamzah
handier113817443handier
handily143610873handily
handing123518893handing
haniwa1236743haniwa
hant75461593ha_nt_
hants86335403ha_nts
haplite12310703haplite
haptic13511893haptic
hardier114721543hardier
hardies114923233hardies
hardily143310273hardily
haring104233003haring
harsh116418053ha_rsh
hart76865773ha_rt_
harts88441593ha_rts
hash106936503ha__sh
hashish1238353hashish
hast76259483ha_st_
haste85927863ha_ste
hasty115718763ha_sty
hat67289963ha__t_
hatch135719593ha_tch
hate78450173ha__te
hating104929713hating
hats76858253ha__ts
haugh125114053ha_ugh
haunch14377343haunch
haunt85229133haunt_
haunts95614393haunts
haut75949733ha_ut_
haute89521613ha_ute
having134220373having
havior1248203havior
hawing134322353hawing
hawkish2036553hawkish
haying134420613haying
hazier184712403hazier
hazily2179063hazily
hazing194218553hazing
headfish1845443headfish
headier113212953headier
headily1478623headily
heading122919113heading
health124712143health
hearth125315213hearth
heath115724283h_eath
heigh124812543h_eigh
heth107028023h__eth
hiding114319333hiding
high116619923h__igh
highth12389153highth
hit66569193h__it_
hitch134515473h__itch
hits75545133h__its
hyacinth1962613hyacinth
hyalite13229473hyalite
indite73520323indite
jacinth1954603jacinth
jadeite1546403jadeite
jading154214023jading
jaditic1746703jaditic
kaddish16317973kaddish
kadi96224833kadi__
kadis105921063kadi_s
kaliph1537873kaliph
khadi1367603khadi__
khadis1446913khadi_s
kith115826363__kith
laddish12299723laddish
ladies75124883ladies
lading84227123lading
ladino73615123ladino
ladyish14287823ladyish
laich105920713la_ich
laigh95515923la_igh
laity85318903la_ity
lath76640383la__th
latish92416173latish
lavish124112983lavish
laxity1637273laxity
maddish14289483maddish
maidish13239553maidish
manito8518693manito
manitu8315823manitu
marish114319053marish
math95437453ma__th
modish123813543modish
nadir61012973nadi_r
nadirs7109003nadirs
nudity1037993nudity
oafish121311723oafish
oath76132153oa__th
oddish11107653oddish
oddity1135243oddity
oldish10169313oldish
oolith93813243oolith
padi76331783padi__
padis86227143padi_s
palish114718273palish
pandit93820753pandit_
pandits103914213pandits
pariah114320583pariah
parish115022353parish
parity114719873parity
path99134913pa__th
pith95432693__pith
podite93315353podite
qadi145621103qadi__
qadis155917853qadi_s
radial74020393radial
radian74117273radian
radiate83416313radiate
radii64016413radi_i
radio64922493radi_o
radios74018673radios
radium93513293radium
radius73914873radius
radix134414603radi_x
raita54623073ra_ita
rakish134313963rakish
rarity93615493rarity
rath76037663ra__th
ratite65022423ratite
ravish123414033ravish
rawish123012913rawish
sadi55834643sadi__
sadis64930853sadi_s
sadism94113493sadism
sadist74221353sadist
sadists83310853sadists
saithe94713913sa_ithe
samite83020603samite
sanity9316203sanity
shadier113111153shadier
shadily1437723shadily
shading123115563shading
shantih13309643shantih
shariah132210533shariah
sith75435153__sith
smith107818053_smith
swith115917403_swith
tacit76333673tacit_
tallith102913063tallith
taxite13511303taxite
toadish1139063toadish
vanish121513213vanish
vanity12311933vanity
wadi86228173wadi__
wadies105121203wadies
wading114619533wading
wadis95223963wadi_s
wait75553693wa_it_
waits88333523wa_its
wapiti1138363wapiti
warmth1477933warmth
widish13419363widish
width12310963wid_th
with105730473__with
wraith1258603wraith
zenith1839073zenith
zizith1744823zizith

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127163094.76623650.0
3Display Results3093090.0933322.6
 (SQL Overall)1786913095.23234153.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.