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

188 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
kashered163640(None) 
koshered1636061koshered
adhered1239232_adhered
ashlered1244622_ashlered
cashiered1543402cashiered
coshered14610292coshered
fathered151510432fathered
gathered13149382gathered
kasher134915032kasher__
kashers143914022kasher_s
lathered121512332lathered
mastered112614002mastered
ushered1139152_ushered
adhere10310333_adhere_
adherend1343863_adherend
adherer1137573_adherer
adheres11310163_adheres
altered83215743_altered
angered93013473_angered
answered1235493answered
ascared10399523_ascared
ashamed1336243_ashamed
ashed97829773_ash__ed
ashlared1253933_ashlared
ashore9414613_ashore_
aspersed11428293_aspersed
aspired1068173_aspired
asserted957903_asserted
assured858373_assured
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
bashed126225703bash__ed
basher115123813basher__
bashers124820833basher_s
basseted1136753basseted
battered113315053battered
bistered112913333bistered
blathered15168363blathered
bothered142110393bothered
busheled1465273busheled
cacheted16148233cacheted
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043ca_pered
careered1139493careered
cashed125124353cash__ed
cashmere1564323cashmere_
cashmeres1654393cashmeres
casketed1534953casketed
catered103117773ca_tered
ciphered1637053ciphered
cohered133514693_cohered
cyphered1934653cyphered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
dashed115920563dash__ed
dasheen1136393dashe_en
dasher104318983dasher__
dashers115016863dasher_s
dithered13189293dithered
easeled8159863eas_eled
ensphered1565283ensphered
faltered122810993faltered
fashed136720253fash__ed
fastened12257853fastened
feathered16188893feathered
festered122512113festered
fostered122210453fostered
gandered112211173gandered
garnered10247113garnered
gartered10319593gartered
gashed116321973gash__ed
gasher104320373gasher__
gatherer12147913gatherer
hachured1744393hachured
haltered123112563haltered
hammered16218853hammered
hampered16239933hampered
hankered16289443hankered
harshened1644453harshened
hashed136021943hash__ed
hastened12239103hastened
havered144011453ha_vered
heathered16149463heathered
inhered11313163_inhered
insphered1564783insphered
jabbered2034433jabbered
kashering1736253kashering
kashrut1444913kash_rut
kippered17255623kippered
knackered1543683knackered
kosher134412973kosher__
koshers144811803kosher_s
laagered1055853laagered
lackered15108683lackered
laddered1136743laddered
lagered92311153la_gered
lappered13288213lappered
lashed105625213lash__ed
lasher94824533lasher__
lashers104121833lasher_s
latherer111310453latherer
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
leathered13148713leathered
lechered1437523lechered
lustered92510603lustered
mammered12237653mammered
mannered11249653mannered
mashed125325043mash__ed
masher114123203masher__
mashers124621053masher_s
mattered112412903mattered
mothered142310103mothered
mustered112511503mustered
nattered92011623nattered
ochered132610283_ochered
osiered837123_osiered
oystered1236923oystered
paltered113012493paltered
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
pashed125923143pash__ed
pastored1139973pastored
pastured1138233pastured
pattered112714203pattered
paupered13216943paupered
pestered112814973pestered
plastered1288903plastered
pothered142311043pothered
racheted14149503racheted
raftered1237663raftered
rapiered1136053rapiered
rasher95024123rasher__
rashers104020913rasher_s
sabered103213023sa_bered
sacheted14127833sacheted
saggered11237553saggered
sashayed1543553sashayed
sashed105622943sash__ed
sered65737293__s_ered
shared105829063__shared
sheared114516003__sheared
sheered113515453__sheered
sherd96321153__sher_d
shewed134716183__shewed
shored105723653__shored
shred98125613__sh_red
sistered92612803sistered
slathered13148553slathered
sphered133512313_sphered
syphered1755013syphered
tabered103311593ta_bered
tampered13279463tampered
tapered102612933ta_pered
tasseled935603tasseled
tattered92011443tattered
tethered1238493tethered
tochered1437913tochered
unshared121510703unshared
unsphered1556103unsphered
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
washed135521503wash__ed
washer124720393washer__
washermen1743383washermen
washers134517523washer_s
watered113014953wa_tered
wavered142910433wa_vered
weathered16168513weathered
westered122511873westered
withered15169433withered
wuthered15157433wuthered
yabbered1633963yabbered
yammered16225763yammered
yattered12239533yattered

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621886.29623215.1
3Display Results1881880.0762473.7
 (SQL Overall)1786911886.79526297.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.