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

114 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
midrash133542(None) 
madras94316422madras_
madrasa10387882madrasa
madrasah14324782madrasah
midrashic1752972midrashic
midrashim1752162midrashim
midrashot1552892midrashot
mudras94212252mudras_
amidase1036723amid_ase
brash106221563__brash
crash109120013__crash
dash87031633__d_ash
deash95617243__deash
digraph14146633digraph
emdash12244113emd_ash
endash10297123end_ash
girsh95310023gi_r_sh
hijrah1934273hijra_h
hijrahs2043443hijrahs
hijras1635773hijras_
hydras13239313hydras_
hydrase14287663hydrase
ideas65919013_ideas_
inrush936513_inrush
kiddish16276583kiddish
kiddush16242483kiddush
libras83711703libras_
lidars7310783lidars_
liras56021983li_ras_
maddish14289483maddish
madrasahs15243853madrasahs
madrasas11317763madrasas
madrases112610003madrases
madrassa11274623madrassa
madrassah15293083madrassah
madres93718183madres_
maidish13239553maid_ish
maras75443283m_aras_
marish114319053m_arish
marsh105320853m_ar_sh
mash96039393m___ash
matrass939393matrass
mbiras1077143mbiras_
medias93620783medias_
miasm91211093mi__asm
micas96823053mi_cas_
micra96214973micra__
micros104115363micros_
midair937983mid_air
midbrain1343923midbrain
midcap1336473midca_p
midday13327503midda_y
middays14335663middays
midges103516473midges_
midis85923403mid_is_
midland1136603midland
midlist10312513midlist
midmost1246153midmost
midrange1244433midrange
midrashoth195813midrashoth
midrib1138233midr_ib
midribs1235493midribs
midriff1645503midriff
mids76541773mid__s_
midst85922553mid__st
midsts95510053midsts_
midwatch1941993midwatch
midway15327153midwa_y
midways16386183midways
migrant10314313migrant
migrate101314163migrate
mihrab1335523mihra_b
mihrabs1444203mihrabs
mikra114610313mikra__
mikvah18143473mikva_h
mikvahs19162493mikvahs
milpas101710273milpas_
minas75434113mi_nas_
minish115216293mi_nish
minxish1936213minxish
mirage92313653mi_rage
mires75640883mi_res_
mirks115122143mi_rks_
mirs66940563mi_r_s_
mirth106418893mi_r_th
mirths114912993mi_rths
mirzas1738173mirzas_
miscast11312403miscast
misdraw1345623misdra_w
misdrawn1444343misdrawn
misdraws1445753misdraws
misease92713043misease
mishmash18133423mishmash
misraise10410523misraise
misrate91319143misrate
mitral81314323mitra_l
mitres83922073mitres_
modish123813543mod_ish
moorish123311783moorish
moras76438763m_oras_
morass84614493m_orass
mudfish1646263mudfish
mudra83912433mudra__
muras75329563m_uras_
murras84916003murras_
rash76039933___rash
sirrah9379753sirra_h
sirrahs10377303sirrahs
sirras63814863sirras_
thrash12258353_thrash
tiaras6314533tiaras_
tigrish1137563tigrish
trash86119763__trash
widish13419363wid_ish

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.1561145455.1
2DLD Change Limit1340271146.89319443.9
3Display Results1141140.0432651.2
 (SQL Overall)1786911147.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.