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

206 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
diastem1031804(None) 
diastema11264741diastema
diastems11226521diastems
diaster82813311diaster
diadem1037582dia_dem
diastemas12234392diastemas
diasters92913182diasters
diatom939452dia_tom
diester83013682diester
disaster949942disaster
piaster93012882piaster
aster55434893__aster
baste74829983_baste_
basted95227233_basted
baster85333593_baster
bastes85330383_bastes
biased94012223bias_ed
biases84618433bias_es
biassed10418703biassed
biasses94911653biasses
bilsted1038033bilsted
bister84922763bi_ster
blasted104213473blasted
blastema1244683blastema
blaster94017303blaster
boasted104113743boasted
boaster94616433boaster
caste75932363_caste_
caster85232573_caster
castes85631863_castes
chaste114617393chaste_
chasten124312403chasten
chaster124718503chaster
cisted95217523ci_sted
coasted104015953coasted
coaster94219043coaster
dabster1036703dabster
dafter104813343d_after
daises74318983dais_es
daisied93410013daisied
daisies84217093daisies
darted84620923d_arted
darter75320363d_arter
dashed115920563d_ashed
dasher104318983d_asher
dashes106124983d_ashes
date56443323d_a_te_
dated75530993d_a_ted
dater65332313d_a_ter
dates65639153d_a_tes
datum8310633d_a_tum
dauted84114933d_auted
dawted11489683d_awted
deashed123411303deashed
deashes113313903deashes
demasted1238763demasted
diabetes1147023diabetes
diadems1135393dia_dems
diagram1147363diagram
dialed84716453dia_led
dialer74315433dia_ler
dialled9510133dialled
diallel845683diallel
dialler848813dialler
diameter1148053diameter
diaper94513113dia_per
diaries83321953diaries
diastase946603diastase
diastases1047073diastases
diastemata1352433diastemata
diastole947563diastole
diastoles1047493diastoles
diastral946993diastral
diatoms1039073dia_toms
dicast9315573dicast__
dicastic1347343dicastic
dicasts1078703dicast_s
dictum1136863di_ctum
didst74619613didst__
diesel74410403dies_el
dieses75218693dies_es
diesters92513603diesters
diestrum1145363diestrum
dieted83115493di_eted
dieter73516773di_eter
digested11208163digested
digester10258433digester
dighted132511493dighted
dilate73220693dilate_
dilated93115823dilated
dilater83515653dilater
dilates83220663dilates
dilute72911803dilute_
diluted9248933diluted
diluter8319663diluter
dilutes82911973dilutes
dimeter10411893dimeter
dinted84419843di_nted
diopter1038473diopter
disarm9310473di_sarm
disasters1039153disasters
disced104914653di_sced
disesteem1244623disesteem
dished114318713di_shed
dishelm1335833di_shelm
dishes104622653di_shes
disked125015763di_sked
dismasted1346833dismasted
disme85716243di_sme_
dismes95617673di_smes
dispel9310323di_spel
dissed85220183di_ssed
disses75225963di_sses
distal73615773di_stal
distaste939943distaste_
distasted1137963distasted
distastes1039633distastes
distend93312073di_stend
distent84120853di_stent
distil73616433di_stil
distome10313233di_stome
dite55547553di__te_
dites66339153di__tes
ditsier83010293ditsier
divested13268213divested
doated84118183doa_ted
drafted12439033drafted
draftee11379523draftee
drafter11449423drafter
dragster1034623dragster
drastic10310873drastic
dratted9358593dratted
dusted83918373d_usted
duster74919723d_uster
easter65027983_easter
fasted105320953_fasted
fasten95114893_fasten
faster94625773_faster
feasted11310843feasted
feaster10812983feaster
fibster12146533fibster
fisted104218703fi_sted
gasted84821583_gasted
gaster75027353_gaster
haste85927863_haste_
hasted105125283_hasted
hasten95718563_hasten
hastes95727073_hastes
hipster12288783hipster
histed104420243hi_sted
instep838193_instep
item65620383_i__tem
kiester11329973kiester
lasted74323603_lasted
laster64830633_laster
listed74322833li_sted
listee64223063li_stee
listel64214743li_stel
listen64816813li_sten
lister64527253li_ster
masted94025803_masted
master84831343_master
miasm91211093mias__m
minster93914323minster
misate81222693misate_
misstep11158463misstep
misted93625823mi_sted
mister84728563mi_ster
misterm114314513mi_sterm
paste74932953_paste_
pasted94426903_pasted
pastel85918713_pastel
paster85734373_paster
pastes85233913_pastes
piasters102912813piasters
piastre9307893piastre
piastres10249303piastres
pilaster1038163pilaster
pinaster1037113pinaster
pipestem1443743pipestem
piste75824603pi_ste_
pistes85325633pi_stes
plaster93318693plaster
raster64731443_raster
roasted83912663roasted
roaster74116663roaster
satem76021463_sa_tem
sister64421583si_ster
stem610628253___stem
system1135743_system
taste55127233_taste_
tasted74123973_tasted
taster64930573_taster
tastes64126423_tastes
tipster9299053tipster
toasted84011923toasted
toaster74414463toaster
vaster94521023_vaster
waisted114210943waisted
waister103812383waister
waste86125053_waste_
wasted104423023_wasted
waster95228943_waster
wastes96224883_wastes
wisted104120273wi_sted
yeasted1138503yeasted

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.406440125.6
2DLD Change Limit1340272067.00319138.5
3Display Results2062060.0762710.5
 (SQL Overall)1786912067.48523873.2
 
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.