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

124 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
mihrab133552(None) 
mihrabs1444201mihrabs
ihram10310182_ihram
micra96214972micra_
midrib1138242midrib
mikra114610312mikra_
mitral81314322mitral
ashram1139053ashram
bicarb1238543bicarb
chiral114614413chiral
citral81113893citral
crab85727673__crab
diram84419473di_ram
dirham12378273dirham
dishrag1246273dishrag
drab76226453__drab
grab75427613__grab
hijab1736803hi_jab
hijra1535643hijra_
hijrah1934283hijrah
hijras1635773hijras
ihrams1137173_ihrams
jihad1635913jih_ad
liblab1035083liblab
libra74712423libra_
librae84310173librae
libras83711703libras
lira46928683li_ra_
liras56021983li_ras
madras94316433madras
mara67444573m_ara_
maras75443293m_aras
marram10313883marram
mbira977973mbira_
mbiras1077153mbiras
mib76946123mi___b
mica86428253mi_ca_
micas96823053mi_cas
micro94715993micr_o
microbe1338663microbe
micron103714283micron
micros104115363micros
midcap1336473midcap
midday13327503midday
midrash1335423midrash
midribs1235513midribs
midway15327153midway
migrant10314313migrant
migrate101314173migrate
mikron12318503mikron
mikvah18143473mikvah
milia72719573milia_
milneb1095953milneb
milpa92111403milpa_
milpas101710273milpas
mimbar1297493mimbar
mina65136923mi_na_
minae75627723mi_nae
minas75434113mi_nas
mineral9312743mineral
minicab13177173minicab
minilab11126003minilab
minyan1138173minyan
mir57046773mi_r__
mirage92313653mi_rage
mire66748233mi_r_e
mired85729223mi_red
mires75640883mi_res
mirex146816623mi_rex
miri66730373mi_r_i
mirin75023153mi_rin
mirk106729503mi_r_k
mirks115122143mi_rks
mirky146315523mi_rky
mirror848003mirror
mirs66940573mi_r_s
mirth106418893mi_rth
miry96326753mi_r_y
mirza16410443mi_rza
mirzas1738183mirzas
misdraw1345623misdraw
miseat82925713miseat
mishap1338873mishap
mishear1238393mishear
miskal123710263miskal
mislay113510683mislay
misrate91319143misrate
misread10339723misread
missal84314903missal
missay114112143missay
mistral91013643mistral
mitre75522423mitr_e
mitred94414343mitred
mitres83922073mitres
moira71012023moira_
moirai886913moirai
mora66641273m_ora_
morae75831193m_orae
moral75533433m_oral
moras76438783m_oras
moray105423793m_oray
mudra83912433mudra_
mudras94212263mudras
mura65633303m_ura_
mural75225113m_ural
muras75329583m_uras
murra74519083murra_
murras84916013murras
rehab10312443reh_ab
ricrac1037013ricrac
riprap1055513riprap
scarab10310063scarab
shrub104814893_shrub
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
thiram1139963thiram
thraw1110515923_thraw
throb109816853_throb
tiara5315913tiara_
tiaras6314553tiaras
viral86419593vi_ral
wirra83210823wirra_
ziram163912893zi_ram

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 Limit1127161245.36021029.1
3Display Results1241240.0304133.3
 (SQL Overall)1786911245.76331006.6
 
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.