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

191 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
presumed133797(None) 
presume11310301presume_
presumer1247581presumer
presumes1239841presumes
resumed10310621_resumed
perfumed1654542perfumed
prearmed1397992prearmed
precured1339992precured
preluded1236472preluded
premed114617762pre__med
presaged1238802presaged
presided12410552presided
pressed103317312pres_sed
pressmen1238832pressmen
pressured1237332pressured
presumedly1852542presumedly
presumers1336372presumers
prevued1337142prevu_ed
relumed1069812_relumed
resume8313782_resume_
resumer9410112_resumer
resumes9313372_resumes
assumed1065293_assumed
breamed124011593bre_amed
consumed1337923consumed
creamed123913713cre_amed
crested103416543cres_ted
dreamed114310633dre_amed
dressed93511873dres_sed
frescoed1436053frescoed
freshed143312593fres_hed
freshmen1656023freshmen
peplumed1543043peplumed
perdured12287403perdured
perfume1446503perfume_
perfumer1574553perfumer
perfumes1555893perfumes
perfused1445843perfused
perjured18286273perjured
permed115217353p_e_rmed
permuted1336713permuted
persuade1145853persuade
persuaded1344373persuaded
peruked14367893p_eruked
perused103112203p_erused
pestled102711453p_estled
pleasured1244193pleasured
plumed114412883p__lumed
preached163412063preached
preacted132710943preacted
preaged11612333pre_aged
preassured1344533preassured
prebaked1737173prebaked
prebuild1344303prebuild
preceded1438293preceded
precised133213413precised
precited133013813precited
precluded1544223precluded
precoded1438863precoded
precure11312553precure_
precures12312903precures
predated12513273predated
predried12309573predried
preed85128123pre___ed
preened103214993pre_ened
prefaced1638423prefaced
prefaded1537823prefaded
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
preformed17176203preformed
prefund1335733prefu_nd
prefunded1644693prefunded
pregame1239553pregame_
pregames1339003pregames
preguide1255423preguide
preguided1443923preguided
prehuman1545033prehuman
prejudged2142753prejudged
prelude1038013prelude_
preluder1135733preluder
preludes1137833preludes
premeds12389593pre__meds
premen105017803pre__men
premised133013193premised
premixed20338013premixed
premune1138933premune_
prename11412643prename_
prenames12311643prenames
prenomen1249633prenomen
prenumber1543163prenumber
preowned1435213preowned
prepared132210873prepared
prepaved16177233prepaved
prepped11329903pre_pped
prepubes1436053prepubes
prepuce1337833prepuce_
prepuces1438583prepuces
prequel1836343prequ_el
presage10312293presage_
presager1138443presager
presages11312203presages
presale9416353presale_
presales10315263presales
prescind1338393prescind
prescored14409403prescored
prese75228383pres__e_
presented12311633presented
preserved15107563preserved
preset84430983pres__et
preshaped1745523preshaped
preshowed1875183preshowed
preside10715613preside_
presider11410423presider
presides11414913presides
presifted1536873presifted
presleep1244493presleep
presliced1435983presliced
presoaked1635653presoaked
presold1059603pres_old
presolved1545273presolved
presorted1239453presorted
presser93717623pres_ser
presses93523153pres_ses
pressman1247163pressman
pressure1039773pressure_
pressures1149063pressures
prestamped1742963prestamped
prester93519623pres_ter
prestored125111673prestored
presuming1437663presuming
presummit1553133presummit
presurvey1744603presurvey
pretaped13339133pretaped
prettied1159253prettied
pretyped16306123pretyped
prevised143611073prevised
prevue1179163prevu_e_
prevues1239263prevu_es
prewarmed17104563prewarmed
prewired14358473prewired
preyed125313203pre__yed
priested1138393pries_ted
primed115118913pr__imed
primmed14388853pr_immed
prised94322203pris__ed
prisoned1138813prisoned
prissed103311263pris_sed
procured1336603procured
produced1456073produced
prosed94921103pros__ed
pruned93413113pr__uned
pursued10388133pursu_ed
reamed94326123_re_amed
rearmed103912823_rearmed
reassumed1243793_reassumed
rebuked14438343_rebuked
recused104714433_recused
reduced11610323_reduced
refuged125410873_refuged
refused115114443_refused
refuted114313803_refuted
relume8313273_relume_
relumes9612513_relumes
renamed103114523_renamed
repumped1534383_repumped
reputed104613483_reputed
resawed113111183_resawed
rescued10410043_rescued
reseed74823293_res_eed
resewed113011823_resewed
reshoed112212153_reshoed
resided95217703_resided
resiled84621983_resiled
resined84522653_resined
resited85122423_resited
resized174614903_resized
resoled84119283_resoled
resowed113712253_resowed
rested74430783_res_ted
resulted939713_resulted
resumers1038083_resumers
resurged1038623_resurged
retimed104714653_retimed
retuned86613973_retuned
reused75419563_re_used
subsumed1344943subsumed
treasured1044983treasured
tressed83714263tres_sed
wrested113410933wres_ted
wrestled12296763wrestled

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 Limit1461621916.54622328.4
3Display Results1911910.0802387.5
 (SQL Overall)1786911917.04925349.8
 
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.