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

164 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
drachms153425(None) 
drachm1436491drachm_
drachma1544301drachma
drachmas1644861drachmas
braches144621222braches
brachs134415752brach_s
dachas124113252d_achas
drachmae1643932drachmae
drachmai1653242drachmai
drams86025832dra__ms
oraches124216472oraches
rachis114017652_rachis
aches106132293__aches
apaches143411833apaches
arches114822043ar_ches
baches135426943_baches
beaches144120653beaches
bracers114616703bracers
braces108427773brac_es
brach126123303brach__
brachet144020313brachet
brachets154311983brachets
brachia141910423brachia
bracts105617773brac_ts
brahma1336193bra_hma
brahmas1436733bra_hmas
branches153613803branches
brashes124518463brashes
breaches153714123breaches
brechams1745773brechams
broaches153211623broaches
caches137926913_caches
clachs133511323clach_s
coaches144018693coaches
cracks144817003crac_ks
crams96229153cra__ms
cranches153114543cranches
crashes124618403crashes
cratches153012543cratches
creches14313093creches
daces85030683d_ac_es
dacha114812573d_ach_a
dahls95012283d_a_hls
dahs88231813d_a_h_s
dams77444373d_a__ms
dashes106124983d_ashes
dashis104414393d_ashis
datchas1347423datchas
datums936353d_atums
deacons10310393deacons
deashes113313903deashes
deaths105914443death_s
detaches1439653detaches
diacids1137863diacids
diadems1135393diadems
diatoms1039073diatoms
dirams94413703dira__ms
ditches133215713ditches
douches134315233douches
drabs85119673dra__bs
dracena1034923dracena
dracenas1145793dracenas
draffs13617903dra_ffs
drafts105012533dra_fts
dragees9359483dragees
dragons938383dragons
drags75521113dra__gs
drails74716953dra_ils
drains73719403dra_ins
drakes114715863dra_kes
dram75832003dra__m_
drama85117413dra__ma
dramas95814653dra_mas
drapers105313353drapers
drapes95419653dra_pes
drats66628373dra__ts
draughts13284753draughts
drawees11378363drawees
drawers113610073drawers
drawls105511393dra_wls
draws95119373dra__ws
drays95819773dra__ys
dreams94513983dr_eams
drecks13459203drec_ks
drenches14309803drenches
drums85415873dr__ums
dunches133312583dunches
earaches13411303earaches
fracas11311993frac_as
fractus12146593fractus
graces94523493grac_es
grahams1335333grahams
grams85327313gra__ms
graphs124510153graph_s
kwachas1943063kwachas
laches116528343_laches
larches124416443larches
leaches123319343leaches
loaches123613983loaches
maches134827233_maches
machos135217493_machos
machs125722563_mach_s
marches143921173marches
nachas114914193_nachas
naches114622413_naches
nachos115014183_nachos
orach105219233orach__
orache114013593orach_e
oracles93212423oracles
orchis11710773or_chis
pachas135017143_pachas
parches143720003parches
peaches144120053peaches
poaches144416943poaches
praams10459643pra_ams
prahus11458243pra_hus
prams96125513pra__ms
preaches153214893preaches
raceme1039733_raceme
racemes1139093_racemes
racers84725433_racers
races74943243_rac_es
rachet115028973_rachet
rachets124516833_rachets
racism103214193_racism
racisms112310813_racisms
racks115028853_rac_ks
racons84319343_racons
rams65950773_ra__ms
ranches123620113_ranches
ranchos123911393_ranchos
raphes115117453_raphes
raphis114014323_raphis
rashes95330153_rashes
ratches123620463_ratches
reaches123423203reaches
rhachis1555693rhachis
riches115022083_riches
roaches123616213roaches
ruches114819583_ruches
sachems14348903_sachems
sradhas1176153sradhas
taches114224173_taches
tachs105820933_tach_s
teaches122718353teaches
teraohms1343703teraohms
tracers94917843tracers
traces85329933trac_es
trachea12311673trachea
tracheas13410273tracheas
trachle12311853trachle
trachles13311753trachles
trachoma15116623trachoma
trachomas16126413trachomas
tracks124818843trac_ks
tracts85019073trac_ts
trams75327673tra__ms
tranches132915513tranches
trashes104119263trashes
troches123715343troches
uracils939373uracils
wracks154711113wrac_ks
wraths123810083wrath_s
yachts1437023_yachts

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.436409841.7
2DLD Change Limit1340271647.11018850.5
3Display Results1641640.0762157.9
 (SQL Overall)1786911647.62223444.1
 
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.