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

171 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
hadiths143602(None) 
hadith13312061hadith_
adits66523712_adit_s
faiths124610272fa_iths
habits113014652habit_s
habitus12338172habitus
halites103221192halites
halitus10339962halitus
adieus739633_adieus
adios65822863_adi_os
adit56443663_adit__
admits9411413_admit_s
agitas7310593_agitas
airths95414253_airths
aits46355543_a_it_s
audits72814113audit_s
axites134913833_axites
azoths18366203_azoths
baith108023133ba_ith_
baits76630583ba_it_s
banditos11347633banditos
bandits103814793bandit_s
barites94322333barites
baths105922923ba__ths
briths115113863_briths
cadets96316513cadet_s
cadis84428503cadi__s
caliphs1436753caliphs
carditis11310233carditis
caritas93316963caritas
casitas93312043casitas
chedites1438263chedites
dacites101114593dacites
daleths1135323daleths
davits104012363davit_s
ditas65923673__ditas
dites66339153__dites
dits56450533__dit_s
earths95014593ea_rths
edits65819033_edit_s
endites83717063endites
eoliths10318573eoliths
fadings12469303fadings
faith115620853fa_ith_
fajitas1734253fajitas
friths124313583_friths
gadids95611823gadi_ds
gadis74825293gadi__s
gaits65726013ga_it_s
garths104111503ga_rths
griths105211653_griths
habit103027023habit__
habitan1236903habitan
habitans1346623habitans
habitat12411053habitat
habitats1346733habitats
habited1337883habited
habitue12266703habitue
habitues13306413habitues
hades96035113had__es
hading113922943hadi_ng
hadjees18356383hadjees
hadjes175210403had_jes
hadjis17439653had_jis
hadrons113314303hadrons
hadst93220223hadst__
haets86525123ha_et_s
haffits1636193haffit_s
hafizes2235983hafizes
hafts116219463ha_ft_s
hahs108333363ha___hs
haiks125120933ha_i_ks
haikus13538293ha_ikus
hails85231643ha_i_ls
haints94417583ha_ints
hairs86225173ha_i_rs
hajis156716283haji__s
hakims1537303haki_ms
halides113416663halides
halids104016133hali_ds
halite93624233halit_e
hallahs133912463hallahs
halts85230103ha_lt_s
halvahs16417533halvahs
hamates122917683hamates
hamzahs24134373hamzahs
hants86335403ha_nt_s
haplites1339993haplites
hardies114923233hardi_es
harts88441593ha_rt_s
hastes95727073ha_stes
hates86742573ha__tes
hath105933913ha__th_
hats76858253ha__t_s
haughs13408563ha_ughs
haunts95614393haunt_s
haviors1347383haviors
hayings14379393hayings
hazings20378343hazings
headings133510493headings
healths13478753healths
hearths135311073hearths
heaths126316383h_eaths
heths116317783h__eths
hidings12349703hidings
highs125412523h__ighs
highths13358003highths
hits75545143h__it_s
hyacinths2071423hyacinths
hyalites14208833hyalites
indites83618983indites
jacinths2042733jacinths
jadeites1645823jadeites
jadish17319913jadish_
jaditic1746703jaditic
kadis105921073kadi__s
kaliphs1634293kaliphs
khadis1446913khadi__s
kiths125814983__kiths
ladies75124883ladi_es
ladings93814133ladings
ladinos8389963ladinos
laichs115110893la_ichs
laighs10508803la_ighs
laith85722103la_ith_
laths86022403la__ths
manitos9314053manitos
manitus9310923manitus
maths105624023ma__ths
nadirs7109003nadi_rs
oaths86117313oa__ths
ooliths10268323ooliths
padis86227143padi__s
pandits103914213pandit_s
pariahs123812343pariahs
paths105521383pa__ths
piths105817543__piths
podites103014733podites
qadis155917853qadi__s
radials83614643radials
radians83013823radians
radiates92415293radiates
radices102314263radices
radios74018673radi_os
radish103516923radish_
radishes1269463radishes
radiums10299323radiums
radius73914873radi_us
radixes15259343radixes
raitas64417673ra_itas
ratites74920683ratites
sadis64930853sadi__s
sadisms10359113sadisms
sadists83310853sadists
saith85826553sa_ith_
saithe94713913sa_ithe
samites93118713samites
shadings13327433shadings
shantihs14276213shantihs
shariahs14206393shariahs
smiths114711023_smiths
talliths11377433talliths
taxites1449673taxites
wadies105121203wadi_es
wadis95223963wadi__s
waits88333523wa_it_s
wapitis1236473wapitis
warmths1583783warmths
widths1335123wid_ths
wraiths1355033wraiths
zeniths1935153zeniths

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.406440125.6
2DLD Change Limit1340271716.72019944.5
3Display Results1711710.0602850.0
 (SQL Overall)1786911717.18624866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.