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

222 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
drachm143649(None) 
drachma1544301drachma
drachms1534251drachms
brach126123302brach_
brachs134415752brachs
dacha114812572d_acha
drachmae1643932drachmae
drachmai1653242drachmai
drachmas1644862drachmas
dram75832002dra__m
orach105219232orach_
orache114013592orache
ache96829823__ache
achy126316093__achy
apache134210783apache
arch98628443ar_ch_
bach116131393_bach_
beach124623893beach_
beachy164011253beachy
brace95629273brac_e
braced115420603braced
bracer104620583bracer
braces108427773braces
braches144621223braches
brachet144020313brachet
brachia141910423brachia
brachium1766113brachium
bract96332723brac_t
bracts105617773bracts
brahma1336193bra_hma
branch134014783branch_
branchy17357913branchy
brash106221563brash_
brashy145210593brashy
breach134213723breach_
brecham1646833brecham
broach133611113broach_
broche133612103broche
cache125122483_cache
clach124617823clach_
clachs133511323clachs
coach125919453coach_
crack134120533crac_k
cracks144817003cracks
cracky175010223cracky
cram85635493cra__m
cranch133613533cranch_
crash109120013crash_
cratch134110793cratch_
creche13310763creche
dace76934923d_ac_e
daces85030683d_aces
dachas124113253d_achas
dah78148983d_a_h_
dahl87019223d_a_hl
dahs88231813d_a_hs
dam67457043d_a__m
dash87031633d_ash_
dashi95013113d_ashi
dashy125612383d_ashy
datcha1266563datcha
datum8310633d_atum
deacon9510423deacon
deash95617243deash_
death94822523death_
deaths105914443deaths
deathy134210233deathy
detach12310413detach_
diacid10310633diacid
diadem1037583diadem
diarchy1644673diarchy
diatom939453diatom
diram84419473dira__m
ditch115015093ditch_
douche124613223douche
drab76226453dra__b
drably123511613drably
drabs85119673dra_bs
dracena1034923dracena
draff125615663dra_ff
draffs13617903draffs
draffy16486633draffy
draft95526683dra_ft
drafts105012533drafts
drafty13638933drafty
drag64825053dra__g
dragee84415603dragee
draggy12346823draggy
dragon838843dragon
drags75521113dra_gs
drail65020973dra_il
drails74716953drails
drain65222893dra_in
drains73719403drains
drake104918303dra_ke
drakes114715863drakes
drama85117433dra_ma
dramas95814673dramas
drams86025833dra_ms
drank104816203dra_nk
drape85319633dra_pe
draped105314363draped
draper94315693draper
drapes95419653drapes
drapey125010583drapey
drat56247833dra__t
drats66628373dra_ts
draught12266983draught
drave95219273dra_ve
draw85623013dra__w
drawee104413823drawee
drawer104711363drawer
drawl95516013dra_wl
drawls105511393drawls
drawly134910723drawly
drawn95614243dra_wn
draws95119373dra_ws
dray85428093dra__y
drayed115911393drayed
drays95819773dra_ys
dream85120393dr_eam
dreck124812803drec_k
drecks13459203drecks
drecky16486333drecky
dreich12377723dreich_
drench12369593drench_
drum76521593dr__um
duchy144310873d_uchy
dunch115316263dunch_
dutch114713823dutch_
dyarchy1942503dyarchy
each95530583_each_
earache1239333earache
fracas11311993fracas
fracti1139963fracti
grace85124543grac_e
graced105217903graced
graces94523493graces
graham1237853graham
gram77034583gra__m
granum9310913granum
graph115315613graph_
graphs124510153graphs
kwacha1832983kwacha
larch105919793larch_
leach105422523leach_
leachy14419733leachy
loach105116363loach_
mach116134483_mach_
mache125925303_mache
macho126120153_macho
machs125722563_machs
march125622893march_
nacho105414383_nacho
oraches124216473oraches
oracle84313293oracle
pacha126518063_pacha
parch125123003parch_
peach125422493peach_
peachy164510843peachy
poach124917863poach_
poachy16388963poachy
praam94815613pra_am
prahu105013973pra_hu
pram85733493pra__m
preach133613923preach_
preachy17307313preachy
race66746263_rac_e
raced87635313_raced
raceme1039733_raceme
racer75233023_racer
races74943243_races
rachet115028973_rachet
rachis114017653_rachis
racism103214193_racism
rack106234883_rac_k
racks115028853_racks
racon75422143_racon
racy95825683_rac_y
rah68052403_ra_h_
ram56867273_ra__m
ranch105019793_ranch_
rancho114310853_rancho
raphe104916423_raphe
rash76039933_rash_
ratch104221363_ratch_
rath76037663_rath_
rathe85821923_rathe
reach105123883reach_
rich97025553_rich_
roach105717003roach_
ruche104216763_ruche
sachem134012223_sachem
sradha1085333sradha
tach96132753_tach_
tache106222373_tache
tachs105820933_tachs
teach105221123teach_
teraohm1244783teraohm
trace75829613trac_e
traced94821583traced
tracer84820233tracer
traces85329933traces
trachea12311683trachea
trachle12311853trachle
trachoma15116623trachoma
track114823013trac_k
tracks124818843tracks
tract75635713trac_t
tracts85019073tracts
tram67034553tra__m
tranche123312223tranche
trash86119763trash_
trashy12509053trashy
troche113112513troche
uracil8311543uracil
wrack145413883wrac_k
wracks154711113wracks
wrath115715873wrath_
wraths123810083wraths
wrathy15377853wrathy
yacht13417393_yacht

Search took 7 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.406440125.6
2DLD Change Limit1127162225.61020092.0
3Display Results2222220.0762921.1
 (SQL Overall)1786912226.09229332.1
 
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.