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

169 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
dirham1237827(None) 
diram84419471dir_am
dirhams13376311dirhams
dirams94413702dir_ams
dirdum1036032dirdum
dram75832002d_r_am
dream85120392d_ream
ihram10310182_ihram
ziram163912892zir_am
airbag956963airbag
airhead1136993airhead
airman82414223airman
airway1237693airway
arhat8327093_arhat
ashram1139053ashram
bream95121813_bream
cham115532313__cham
circa9311403circa_
cram85635493_cr_am
cream95721353_cream
dacha114812573dacha_
dachas124113253dachas
dam67457043d___am
darbar959953darbar
darshan1167063darshan
defoam1238563defoam
derat65044083der_at
deray95024183der_ay
derm76031893der__m
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
dhak125512033d__hak
dhal86719283d__hal
diadem1037583diadem
diagram1147363diagram
dial55935063di__al
diatom939453diatom
dicta84915633dicta_
dictum1136863dictum
diehard1237053diehard
digamy1335893di_gamy
dight104027003digh_t
dights114016963dights
diktat11310693diktat
dim68146493di___m
dinar66319893di_nar
dinkum1335893dinkum
diorama1046533diorama
dioxan1465773dioxan
diphase1387273diphase
dipsas9359893dipsas
diquat1639763diquat
dirdums1134383dirdums
dire56644143dir__e
direct93817333direct
direly10311563direly
direr64927073dir_er
direst75024243direst
dirge75117073dir_ge
dirges84915103dirges
dirk96326833dir__k
dirked124912273dirked
dirks105619523dir_ks
dirl57430023dir__l
dirled84514903dirled
dirls64720503dir_ls
dirndl834253dirndl
dirt55550383dir__t
dirtbag1143023dirtbag
dirts66824463dir_ts
dirty95617803dir_ty
disarm9310473disarm
disbar938513disbar
dish86328333dish__
dished114318713dished
dishelm1335833dishelm
dishes104622653dishes
dishpan13105523dishpan
dishrag1246273dishrag
dishy125712353dish_y
dismal92412243dismal
dismay12229473dismay
distal73615773distal
dita56032523di_ta_
ditas65923673di_tas
dither104417683dither
diurnal844883diurnal
diva85920883di_va_
divan96114843di_van
divas95418583di_vas
diwan95712553di_wan
dorhawk1841853dorhawk
dorm76834633dor__m
dorsa64617283dorsa_
dorsad8408973dorsad
dorsal74613943dorsal
dorsum947623dorsum
drab76226453d_r_ab
drag64825053d_r_ag
drama85117423d_r_ama
drams86025833d_r_ams
drat56247833d_r_at
draw85623013d_r_aw
dray85428093d_r_ay
dread74419023d_read
dreams94513983d_reams
dreamt94615713d_reamt
dreamy12509993d_reamy
drear65016903d_rear
drum76521593d_r_um
dryad10477583d_ryad
dunam8313733d_unam
dura55232113dur_a_
dural64923893dur_al
duras65727733dur_as
durbar968723durbar
durian7312003durian
durra65315793durra_
durras74713373durras
durum8513203dur_um
ferbam1339003ferbam
firearm1237203firearm
firm96026453fir__m
firman112211343firman
foram105124933for_am
fulham1435303fulham
gingham1484463gingham
graham1237853graham
gram77034583_gr_am
ham86363283___ham
ihrams1137173_ihrams
imam81718333_i_mam
jihad1635913ji_had
joram145816983jor_am
lingam95112353lingam
lira46928683lir_a_
liras56021983lir_as
marram10313883marram
mihrab1335523mihrab
mirza16410443mirza_
mirzas1738183mirzas
mishap1338873mishap
nizam16310253ni_zam
ogham1138253_ogham
praam94815613_praam
pram85733493_pr_am
ram56867273__r_am
ream65841613__ream
roam67132413__roam
scram910621623scr_am
scream104814253scream
sham96436363__sham
sirdar7269103sirdar
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
stream84717293stream
thiram1139963thir_am
tram67034553_tr_am
viral86419593vir_al
virga9310253virga_
virgas1048883virgas
wham125321693__wham
wigwam1544723wigwam
wirra83210823wirra_
wisha114910853wisha_
withal1238933withal
zirams17438643zir_ams

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 Limit1127161695.39320900.4
3Display Results1691690.0463673.9
 (SQL Overall)1786911695.81230745.2
 
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.