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

158 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
dopester113725(None) 
dopesters1237281dopesters
detester9239682detester
diester83013682d_iester
digester10258432digester
doomster1135842doomster
forester11313672forester
honester1139712honester
jokester1934442jokester
modester1197482modester
molester1099372molester
pester84827592__pester
adopter1036763adop__ter
arrester839253arrester
attester836503attester
bimester1236163bimester
boaster94616433bo_aster
bolster93713423bo_lster
booster94314553bo_oster
coaster94219043co_aster
composter15369563composter
contester11311183contester
copastor1246343copastor
copter109822013cop__ter
coster84331293co__ster
coveter122912063cove_ter
dabster1036703d_abster
decenter112412163decenter
deemster1175713deemster
defeater122611663defeater
defter104215923d__efter
deluster936903deluster
demister11310223demister
dempster1355773dempster
depicter1356853depicter
depleter11298863depleter
deporter1169393deporter
deposer104011843depos_er
deserter91211603deserter
detecter11298733detecter
deter65028043d__e_ter
detested10279623detested
detesters10298303detesters
devested13239133devested
dexter143810893d__exter
diaster82813313d_iaster
diesters92513603d_iesters
dieter73516773d_ie_ter
digested11208163digested
digesters11257883digesters
digestor10246553digestor
dimeter10411893dime_ter
diopter1038473diop__ter
directer1137583directer
disaster949943disaster
diverter12238623diverter
divested13268213divested
doest65829523do_est__
domestic1347813domestic
doomsters1236173doomsters
doorstep1143103doorstep
doper86128393dop___er
dopes84935043dopes___
dopesheet1554693dopesheet
dopier93515923dop__ier
dopiest103315993dopiest__
dorser74819183do_rs_er
doser66228563do__s_er
dosser74417973do__sser
dossier83711693do_ssier
doter65428623do___ter
dotter74419343do__tter
doubter10298353do_ubter
douser75621633do_us_er
dowser104716083do_ws_er
dragster1034623dragster
dresser83611953d_resser
dumpster1344053dumpster
duster74919723d__uster
ester54727713___ester
expecter1936513expecter
fester94723513__fester
fomenter1339263fomenter
foreseer1139013foreseer
forested12312463forested
foresters12312533foresters
foster94322223fo__ster
gamester1137323gamester
gypster1333953gyp_ster
hipster12288783hip_ster
hoister103714203ho_ister
holster103512213ho_lster
hoopster1335543hoopster
imposter12288163imposter
infester11239433infester
jester134319153__jester
jokesters2044443jokesters
jouster143311043jo_uster
keester11319913_keester
kiester11329973_kiester
lobster9288853lo_bster
lodestar944413lodestar
mobster11299213mo_bster
moister94015373mo_ister
molested11178243molested
molesters1198873molesters
monoester1146453monoester
monster93214603mo_nster
nester64124183__nester
odometer1147413odome_ter
oldster896573_oldster
oleaster837263_oleaster
opener83910993_ope_ner
ouster64223733_o_uster
oyster94111703_o_yster
paster85734373__paster
pelter83321623__pelter
penster92811953__penster
perter84422283__perter
pesters93827093__pesters
pestier94317403__pestier
peter74427593__pe_ter
petter83924773__petter
pewter114013673__pewter
pipestem1443743pipestem
polestar1047113polestar
pollster1037103pollster
polyester1445353polyester
poster84129173__poster
prester93519623_prester
protester111510483protester
quester161410023_quester
repeater102615443repeater
repenter102813863repenter
rester63832433__rester
rimester1037813rimester
roadster935463roadster
roaster74116663ro_aster
robuster1035663robuster
roister73516203ro_ister
rooster74415173ro_oster
roster64329083ro__ster
rouster73517083ro_uster
royster103110533ro_yster
semester1038903semester
songster935793songster
specter113111733_specter
spelter94113703_spelter
tapster9299273tap_ster
tester64227153__tester
tipster9299053tip_ster
toaster74414463to_aster
udometer1146333udome_ter
wester94222893__wester
wrester102812413_wrester
yester93417983__yester
zester153617793__zester
zoster153715853zo__ster

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621587.36019859.0
3Display Results1581580.0602633.3
 (SQL Overall)1786911587.84322783.5
 
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.