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

148 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
cadaster113690(None) 
cadasters1236831cadasters
cadastre1144281cadastre
adapter1036172_adapter
cadastres1244552cadastres
cadaver1335792cada_ver
canister101710852canister
caster85232572c__aster
chaster124718502c_haster
coaster94219042c_oaster
cytaster1383862cytaster
abaser86414343_abas_er
abater85518123_aba_ter
adapted1135843_adapted
adapters1136103_adapters
adaptor1034953_adaptor
adepter1036113_adepter
adjuster1644353_adjuster
adopter1036763_adopter
alabaster1143353alabaster
alastor739673_alastor
amasser9418733_amasser
aster55434893___aster
awaiter1057443_awaiter
badassed1244273badassed
badasses1136173badasses
ballaster1145973ballaster
baluster1037053baluster
bandmaster15124413bandmaster
banister10199973banister
baster85333593__baster
blaster94017303_blaster
boaster94616433_boaster
cadastral1243073cadastral
cadavers1435893cada_vers
cadger105013913cad__ger
calashes13310543calashes
calypter1544063calypter
camases114216343camas_es
camasses12388973camasses
canaller1038953canaller
canasta938363canast_a
canastas1037693canastas
canistel10187253canistel
canisters112310193canisters
cannister1155723cannister
canter85230113c__anter
canvaser13276563canvas_er
canvasser14274263canvasser
capabler1435353capabler
carate84734003cara_te_
carates95630613cara_tes
caresser1038813caresser
carter84932273c__arter
caste75932363c__aste_
casters94729903c__asters
castes85631863c__astes
castor84418533c__astor
cater74840723c__a_ter
catheter1338153catheter
caudate10311353cauda_te_
caudated1238063cauda_ted
caudates11310263cauda_tes
causer84117783ca_us_er
cavalier1348183cavalier
cavorter1335783cavorter
cerastes101111093cerastes
chanter123919733c_hanter
chapter144213853c_hapter
character1645883character
charter123918303c_harter
chaser114918383c_has_er
chaste114617393c_haste_
chasten124312403c_hasten
chatter124416643c_hatter
cheater124816963chea_ter
clasher124615513c_lasher
clasper113811863c_lasper
classer93614613c_lasser
clatter94014973c_latter
cloister1037093cloister
cluster94013333c_luster
clyster12317453c_lyster
coadapted1543163coadapted
coasted104015953c_oasted
coasters104317333c_oasters
coater84329573c_oa_ter
copastor1246343copastor
coster84331293c__oster
crafter124111333c_rafter
crasher124616163c_rasher
crasser94114343c_rasser
crater85026643c_ra_ter
creaser94415743creas_er
creasier103210193creasier
cytasters1483663cytasters
dabster1036703da_bster
dafter104813343__dafter
darter75320363__darter
dasher104318983__dasher
dater65332313__da_ter
diaster82813313_diaster
disaster949943disaster
duster74919723__duster
easter65027983__easter
faster94625773__faster
feaster10812983_feaster
gagster9317633ga_gster
gamester1137323gamester
gangster10215773gangster
ganister9178993ganister
gaster75027353__gaster
hamster12810423ha_mster
harasser1137043harasser
headmaster16204643headmaster
lamister1037653lamister
lamster9109913la_mster
laster64830633__laster
loadmaster1343233loadmaster
magister1136283magister
maltster1035303maltster
master84831343__master
modester1197483modester
oldster896573old_ster
oleaster837263oleaster
paster85734373__paster
paymaster1643873paymaster
piaster93012883_piaster
pilaster1038163pilaster
pinaster1037113pinaster
plaster93318693_plaster
radwaste1243843radwaste_
radwastes1364123radwastes
raster64731443__raster
remaster10311473remaster
roadster935463road_ster
roaster74116663_roaster
scamster1235303sca_mster
sedater83713633seda_ter
tapster9299273ta_pster
taster64930573__taster
teataster944563teataster
toaster74414463_toaster
updater10347253upda_ter
vaster94521023__vaster
waister103812383wa_ister
waster95228943__waster
yardmaster1652713yardmaster

Search took 9 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.420425454.8
2DLD Change Limit1461621487.62619166.3
3Display Results1481480.0602466.7
 (SQL Overall)1786911488.10622044.3
 
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.