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

229 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
assume89756(None) 
assumed1065291assumed
assumer965361assumer
assumes967161assumes
assure6610771assure
assize1538632assize
assuage835682assuage
assumers1064962assumers
assured858372assured
assurer767792assurer
assures7611402assures
astute6310762astute
coassume12103972coassume
issue559212issu_e
reassume1044632reassume
resume8313782resume
spume95817312_spume
abduce1197193abduce
abjure1536743abjure
absurd935903absurd
abuse77119563a_buse
accuse103411033accuse
acme86924323a__cme
acumen1049013a_cumen
acute74720363a_cute
adduce1076453adduce
adjure1435843adjure
aflame1138723aflame
ague55725923a_gu_e
aisle55223193ais_le
album92312653album_
albumen1135243albumen
albums10198273albums
algum82711763algum_
algums9208043algums
allude73910903allude
allure63012943allure
alme65832163a__lme
almuce10348213almuce
almude9399933almude
alsike1047913alsike
alum65227613a_lum_
alums75720603a_lums
alyssum1242473alyssum_
alyssums1341963alyssums
ampule10710613ampule
amuse75920833a_muse
anime75423203a_nime
ansae55720973ans_ae
ansate64517863ansate
apse67725383aps__e
aquae142212713a_quae
arame75026623a_rame
arbute8311043arbute
argue64818443argu_e
armure8710133armure
arouse65019983arouse
arse46539273ars__e
arsine64021043arsine
arum66129033a_rum_
arums75517833a_rums
asarum84610913asarum_
asarums9467613asarums
ascus75013583ascu_s
ashamed1336243ashamed
ashmen1168173a_shmen
ashore9414613ashore
aside65122083a_side
aslope839013aslope
aspire8612123aspire
asrama839193asrama
ass37844063ass___
assai5711543ass_ai
assail6610153assail
assais6711963assais
assault747413assault
assay8710283ass_ay
assayed1135593assayed
assayer1035573assayer
assays977903assays
assemble1254823assemble
assent65119953assent
assert64922583assert
asses55629283ass_es
assess65710463assess
asset55932263ass_et
assets65617663assets
asshole1046793asshole
assign736783assign
assist6314603assist
assizes1638453assizes
asslike1137373asslike
assoil688543assoil
assort64916383assort
assuaged1044383assuaged
assuager944343assuager
assuages936273assuages
assumable1344543assumable
assumedly15122323assumedly
assuming1135143assuming
assureds984493assureds
assurers866313assurers
assuror754203assuror
asswage1144673asswage
asthma11126563asthma
asylum1144893asylum_
asylums1243633asylums
attune637983attune
aurum7614963aurum_
aurums849383aurums
ausubo853653ausubo
autumn836013autumn
awesome1245573awesome
azure14911483a_zure
bascule1136573bascule
basque17259083basqu_e
blume95619893_blume
brume95817983_brume
capsule1137343capsule
casque17299273casqu_e
cassene93111543cassene
cassine93817283cassine
coassumed14112933coassumed
coassumes13103893coassumes
consume11510133consume
costume1157853costume
dassie74615573dass_ie
dasyure1153823dasyure
disme85716243dis_me
disuse74012843disuse
ensue54013833ensu_e
ensure63416003ensure
exhume1833803exhume
fissure1036783fissure
flume106021173_flume
fume96727633__fume
fusuma1134503fusuma
glume85120463_glume
grume86218163_grume
hassium1236133hassium_
hassiums1344273hassiums
hassle93711593hass_le
heaume1137543heaume
illume8298223illume
inhume1196583inhume
insure63416603insure
issued746723issued
issuer646623issuer
issues648803issues
lassie64917743lass_ie
legume936913legume
lissome937583lissome
masque17249383masqu_e
massage1039893massage
masse75125293mass__e
masseuse1044253masseuse
massive12289773massive
misuse83213643misuse
neume74414403_neume
oscule838193oscule
passade1039233passade
passage1039803passage
passe75525693pass__e
passee84522023pass_ee
passim10410283passim_
passive12239593passive
passus83610293passu_s
passuses1036773passuses
pastime114611973pastime
pasture9311463pasture
plume94819463_plume
possum1057953possum_
possums1145753possums
presume11310303presume
rassle63813203rass_le
rasure6311423rasure
reassumed1243793reassumed
reassumes1144463reassumes
reassure847343reassure
relume8313273relume
resumed10310623resumed
resumer9410113resumer
resumes9313373resumes
sagum8512873sagum_
salute64418023salute
same65245643__same
satsuma943873satsuma
sauce75121653_sauce
saute55028083_saute
scum85924523_scum_
scums95017423_scums
scute75520943_scute
seme65836653__seme
sesame8311013sesame
shame105726703_shame
shute84520353_shute
slime74925753_slime
slue45332193_slu_e
slum65430513_slum_
slump94816633_slump
slums74623433_slums
some66040383__some
souse56530773_souse
spue66025523_spu_e
spumed114711543_spumed
spumes1021314883_spumes
spumy124610363_spumy
stime76521803_stime
stum65526023_stum_
stump94616463_stump
stums75320083_stums
stupe75217753_stupe
subsume1146713subsume
sue35651463__su_e
sum56346013__sum_
sumo67326313__sumo
sump86331533__sump
sums65837583__sums
supe65932763__supe
sure45447413__sure
swum96416823_swum_
tasse54821843tass__e
tassie66017023tass_ie
tissue637333tissu_e
ugsome934783ugsome
unsure62815413unsure
usque14137733usqu_e
volume11358273volume
wagsome1345213wagsome

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162295.83019333.8
3Display Results2292290.0763013.2
 (SQL Overall)1786912296.31228309.7
 
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.