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

223 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
eschars123718(None) 
escars83913131esc_ars
eschar1136531eschar_
chars105936642__chars
echard1249222e_chard
echards1337962e_chards
escar74011992esc_ar_
escarp10449002esc_arp
escarps11397372esc_arps
escheats1346252escheats
eschews1534552eschews
escolars1045342escolars
eskars10357592es_kars
etchers123411292etchers
eucharis1347442eucharis
scars75433532_sc_ars
schavs1436492_schavs
secpars1138412secpars
anchors123912953anchors
archers124414573archers
ascaris93613323asc_aris
ashcans1235183ashcans
ashlars10297063ashlars
becharm1636843becharm
becharms1745343becharms
bedchairs1742603bedchairs
belchers153510023belchers
benchers153611013benchers
bescours1245093bescours
besmears1234543besmears
cars67364763__c_ars
chads116122233__chads
chairs114916183__chairs
chais107530313__chais
chams126028503__chams
chaos105622863__chaos
chaps125326063__chaps
char95132153__char_
charas114223613__charas
chard116124743__chard
chards125119733__chards
chare105231983__chare
chares115631803__chares
chark144222713__chark
charks155219703__charks
charm126124663__charm
charms135218843__charms
charr104821783__charr
charrs115219193__charrs
chart105038283__chart
charts115823093__charts
chary135023133__chary
chats105730093__chats
chaws135022463__chaws
chays135319743__chays
cochairs1545903cochairs
czars164812913__czars
dachas124113253dacha_s
desugars1043373desugars
ears46356593e___ars
eches106322163e_ch_es
echoers12459693e_choers
echoes114715523e_choes
echos105216463e_ch_os
eclairs935963e_clairs
eclats8313033e_clats
eggars8398973e_ggars
embars103812883e_mbars
enchain1248873enchain
enchains1348523enchains
enchant12313133enchant
enchants1347833enchants
enchase1239473enchase
enchasers1445093enchasers
enchases13310273enchases
endears83710053endears
ephahs1435503e_phahs
ephas10311543e_pha_s
ephors11311403e_phors
escape103811663esc_ape
escapers12337413escapers
escapes113811673escapes
eschalot1346223eschalot
eschalots1444133eschalots
escheat12410413escheat
escheators1574193escheators
eschew1436333esch_ew
eschewals1742623eschewals
eschewers1742883eschewers
escolar946053escolar_
escort84616483esc_ort
escorts9418403escorts
escots84211743esc_ots
escrows1235803escrows
escuage1035113escuage
escuages1145163escuages
escudos1043493escudos
eskar9457453es_kar_
eskers105312223es_kers
espials937093espials
essays965653es_says
esters64627733es_ters
estrays10529403estrays
estuary1034683estuary
etchant1249823etchant
etchants1346023etchants
etcher113912943etcher_
etches114217763etch_es
ethers94518413e_thers
euchre11137663euch_re
euchres1288663euchres
eyebars1245333eyebars
fetchers16328863fetchers
ichors11310423_ichors
inchers123912523inchers
isobars936593isobars
isochors1355673isochors
lahars94013163_lahars
lascars979013lasc_ars
leachers133712813leachers
lechers123313963lechers
lochans1248833lochans
mescals112911573mesc_als
mochas13310663mocha_s
nachas114914193nacha_s
nectars938463nectars
nuchals12216943nuchals
ochers113915303_ochers
orchard1346933orchard
orchards1445913orchards
pachas135017143pacha_s
paschals1566473paschals
peachers153213843peachers
pechans14810503pechans
perchers153611523perchers
pochard1537363pochard
pochards1646853pochards
pshaws14435703ps_haws
psywars1533673psywars
reachers133515723reachers
rechart12314343rechart
recharts1337663recharts
rescuers1037363rescuers
scabs94818643_sc_abs
scads85419963_sc_ads
scags85520973_sc_ags
scalars93711903_scalars
scams94423973_sc_ams
scans74625103_sc_ans
scar66434203_sc_ar_
scare75334463_sc_are
scares85033003_sc_ares
scarf105427143_sc_arf
scarfs114714683_sc_arfs
scarp95724103_sc_arp
scarps104718603_sc_arps
scart76139773_sc_art
scarts85321493_sc_arts
scary105222593_sc_ary
scats75930603_sc_ats
scaurs85512053_scaurs
schav1338313_scha_v
schmears1584103_schmears
schmos13379153_schmos
schnaps1443703_schnaps
scholars1336683_scholars
schorl1179813_schorl
schorls1248353_schorls
schuls11299853_schuls
schuss11186733_schuss
schwas14396983_schwas
scours84913593_scours
scrags95713803_scrags
scrams105216623_scrams
scraps106017243_scraps
sears54744913_s_ears
secpar1037923secpar_
sectary1238273sectary
sectors93116453sectors
seculars10219393seculars
seggars9377783seggars
senhors103512133senhors
sewars94018633_sewars
shads95124483_s_hads
shags95123863_s_hags
shahs115919513_s_hahs
shams105829413_s_hams
shard96125963_s_hard
shards104319173_s_hards
share86437083_s_hare
shares95236413_s_hares
shark126225023_s_hark
sharks135019723_s_harks
sharn84823703_s_harn
sharns95516983_s_harns
sharp104922533_s_harp
sharps115516083_s_harps
shaws116226263_s_haws
shays116021433_s_hays
shears93820903_shears
simars84916933_simars
sitars65417593_sitars
sizars154812623_sizars
smears84714433_smears
soars54732513_s_oars
sofars94712783_sofars
sonars64818973_sonars
sowars94318013_sowars
spars75431543_s_pars
spears84019473_spears
stars55836573_s_tars
sugars7312423_sugars
swears94114073_swears
teachers133212393teachers
tochers123413093tochers
trochars1377853trochars
tsars56717113ts__ars
unchairs1345503unchairs
unchary1537263unchary
ushers94415533us_hers
vicars11712263vic_ars
welchers16338053welchers
wenchers16319213wenchers

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.470380193.6
2DLD Change Limit1340272237.22018563.3
3Display Results2232230.0762934.2
 (SQL Overall)1786912237.76623009.4
 
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.