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

138 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
dirhams1337631(None) 
dirams94413701dir_ams
dirham12378271dirham_
diram84419472dir_am_
dirdums1134382dirdums
drams86025832d_r_ams
dreams94513982d_reams
ihrams1137172_ihrams
zirams17438642zir_ams
airbags1036293airbags
airheads1246133airheads
airways1336243airways
arhats9312973_arhats
ashrams1236653ashrams
breams104815043_breams
chams126028503__chams
crams96229153_cr_ams
creams104715253_creams
dachas124113253dacha_s
dams77444373d___ams
darbars10510093darbars
darshans1286543darshans
defoams1336193defoams
derats74625063der_ats
derays105514253der_ays
dermas94116813derma_s
derms85022893der__ms
dhaks13479703d__haks
dhals95415443d__hals
diadems1135393diadems
diagrams1246133diagrams
dials64925343di__als
diatoms1039073diatoms
dictums1235553dictums
diehard1237053diehard
diehards1346213diehards
digamy1335893di_gamy
dights114016963digh_ts
diktats1235623diktats
dims75435023di___ms
dinars75417563di_nars
dinkums1433673dinkums
diorama1046533diorama
dioramas1145513dioramas
dioxans1555313dioxans
diphase1387273diphase
dipsas9359893dipsa_s
diquats1745983diquats
dirdum1036033dirdum_
directs102710263directs
dirges84915103dir_ges
dirks105619523dir__ks
dirls64720503dir__ls
dirndls933893dirndls
dirtbags1242703dirtbags
dirties83119383dirties
dirts66824463dir__ts
disarms1039043disarms
disbars10310323disbars
dishelms1444723dishelms
dishes104622653dish_es
dishpans14115833dishpans
dishrags1346203dishrags
dismals102010243dismals
dismays13237433dismays
ditas65923673di_ta_s
dithers114016153dithers
diurnals943803diurnals
divans104612393di_vans
divas95418583di_va_s
diwans105110373di_wans
dorhawk1841853dorhawk
dorhawks1941613dorhawks
dorms85723843dor__ms
dorsals84110843dorsals
drabs85119673d_r_abs
drags75521113d_r_ags
dram75832003d_r_am_
drama85117423d_r_ama
dramas95814663d_r_amas
drats66628373d_r_ats
draws95119373d_r_aws
drays95819773d_r_ays
dreads84115023d_reads
dream85120393d_ream_
dreamt94615713d_reamt
dreamy12509993d_reamy
drears74614253d_rears
drums85415873d_r_ums
dryads11436623d_ryads
dunams937833d_unams
duras65727733dur_a_s
durbars1077973durbars
durians839573durians
durras74713373durra_s
durums948153dur_ums
ferbams1435743ferbams
firearms1335403firearms
firmans12238523firmans
firms105217423fir__ms
forams115115913for_ams
fulhams1543983fulhams
ginghams1573903ginghams
grahams1335333grahams
grams85327313_gr_ams
hams96446133___hams
ihram10310183_ihram_
imams91511113_i_mams
jihads1734483ji_hads
jimjams1742073jimjams
jorams154810533jor_ams
lingams104510193lingams
liras56021983lir_a_s
marrams11310123marrams
mihrabs1444203mihrabs
mirzas1738183mirza_s
mishaps1438723mishaps
nizams1735413ni_zams
oghams1245853_oghams
perhaps1446123perhaps
praams10459643_praams
prams96125513_pr_ams
rams65950773__r_ams
reams75729623__reams
roams74919613__roams
scrams105216623scr_ams
screams114810623screams
shams105829413__shams
sirdars8228213sirdars
sirrahs10377303sirrahs
sirras63814863sirra_s
streams94713373streams
thirams1236823thir_ams
trams75327673_tr_ams
virgas1048883virga_s
whams135515643__whams
wigwams1643883wigwams
ziram163912893zir_am_

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.390458182.1
2DLD Change Limit1340271386.98319193.3
3Display Results1381380.0502760.0
 (SQL Overall)1786911387.42324072.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.