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

236 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
amassing113800(None) 
massing104318021_massing
abashing1466622abashing
abasing10610672aba_sing
amazing1938812ama_zing
amusing1039382am_using
biassing11307262biassing
brassing112612302brassing
classing113211792classing
damasking1744602damasking
gassing94216332_gassing
glassing10329972glassing
grassing103311972grassing
harassing1346982harassing
mashing134422242_mashing
masking145116612_masking
masting104325822_masting
messing103916392_messing
missing103619072_missing
mossing103915422_mossing
mussing104015542_mussing
passing104318422_passing
sassing84615552_sassing
smashing143310242smashing
aahing1019015763a_a_hing
abating10413973aba_ting
abusing1049113a_busing
accessing1445833accessing
accusing1336783accusing
adapting1236643adapting
advising1336153advising
agisting1038243agisting
alarming1138583alarming
aliasing9310073aliasing
amain74922913ama__in_
amandine1148553amandine
amass77119683amass___
amassed10388633amass_ed
amasser9418733amass_er
amassers10337843amassers
amasses93912853amass_es
amassment1346413amassment
ambling121411793am_bling
ambushing1744033ambushing
amending12308913amending
amercing1337193amercing
amping114317573am__ping
analysing1345933analysing
apposing1337403apposing
arising83619973a_rising
arousing93811803arousing
ashing107824093__ashing
asking116017233__asking
assassin844073assassin_
assassins843933assassins
assaying1236003assaying
assessing1045173assessing
assign736783__assign
availing1267283availing
avulsing1234433avulsing
awaiting1238273awaiting
awaking1547813awa_king
awarding1356043awarding
bashing135422583_bashing
basing95427663_ba_sing
basking144718613_basking
basting104227203_basting
biasing103512453bia_sing
blasting114013433blasting
blessing1137593blessing
blissing1136873blissing
boasting113512503boasting
bossing103714603_bossing
braising113014563braising
bussing103614623_bussing
bypassing1742953bypassing
campusing1654913campusing
canvassing1643803canvassing
caressing1238803caressing
cashing135022553_cashing
casing94829103_ca_sing
casking144317353_casking
cassina94113163_cassina
cassine93817283_cassine
cassino93512433_cassino
casting104628343_casting
causing103614413_causing
ceasing104118263cea_sing
cessing103814813_cessing
chasing133715893cha_sing
chasseing1554963chasseing
clashing143812193clashing
clasping133310263clasping
coasting113615513coasting
compassing1746553compassing
crashing143512633crashing
crossing112612683crossing
cussing103814273_cussing
damaging1337393dama_ging
dashing125917893_dashing
deashing134210953deashing
degassing1234823degassing
demasting1338453demasting
dissing94517683_dissing
dossing93313273_dossing
dressing102810423dressing
easing74926463_ea_sing
easting84924303_easting
elapsing1146713elapsing
emailing113010043emailing
embossing1444713embossing
erasing8317963era_sing
famishing1845233famishing
fashing144918793_fashing
fasting114522833_fasting
feasing113916653fea_sing
feasting122011323feasting
fessing113812863_fessing
flashing153711553flashing
flossing12247903flossing
fussing113611683_fussing
gashing125119233_gashing
gasking134415913_gasking
gasping113714363_gasping
gassings10438403_gassings
gasting95022763_gasting
glassine9329313glassine
glossing10278883glossing
gnashing1336423gnashing
grasping12348833grasping
grossing103111063grossing
guessing1036243guessing
hashing145020163_hashing
hasping134414903_hasping
hassling1236803_hassling
hasting114725193_hasting
hearsing1239383hearsing
hissing114213143_hissing
imaging1138083ima_ging
impasting1436323impasting
imposing1348463imposing
jessing153710623_jessing
kissing122911053_kissing
lambasting1543343lambasting
lapsing103511163_lapsing
lashing114422893_lashing
lasing74727983_la_sing
lassoing946383_lassoing
lasting84725243_lasting
leashing123310313leashing
leasing83920163lea_sing
liaising937913liaising
macing114221553_ma_cing
madding123711993_madding
mailing102923343_mailing
maiming122912723_maiming
making134823853_ma_king
malling103623663_malling
malting103219083_malting
manning103616383_manning
mapping143413993_mapping
marking144020133_marking
marling103322763_marling
marring103319553_marring
marting103325013_marting
maskings15448753_maskings
masoning1139763_masoning
massaging1346353_massaging
massier93615223_massier
massif11412533_massi_f
massifs1237743_massifs
massive12289773_massive
mating94832913_ma_ting
matting103620143_matting
mauling103315683_mauling
mawing124020803_ma_wing
maxing164817073_ma_xing
maying124421153_ma_ying
mazing184418973_ma_zing
mensing103915103_mensing
meshing134513813_meshing
misting103623383_misting
misusing1138893_misusing
moshing134214883_moshing
mousing103816273_mousing
moussing1138143moussing
mushing134217633_mushing
musing93919503_m_using
musting103221073_musting
parsing103819553_parsing
pashing135120513_pashing
passings11409873_passings
pasting103826553_pasting
pausing103912813_pausing
phasing133211673pha_sing
pissing103914803_pissing
plashing143311063plashing
praising113214563praising
pressing112516443pressing
prissing113011453prissing
quashing2137093quashing
quassin1645943quassin_
quassins1735793quassins
raising83220533_raising
rasing74330833_ra_sing
rasping104316253_rasping
rassling939013_rassling
reassign955423reassign
repassing12249423repassing
roasting93012703roasting
sashing114621473_sashing
slashing123713413slashing
smacking173510763smacking
smarting113212453smarting
smushing14287453smushing
spasming13227203spasming
stashing123511583stashing
sussing84013703_sussing
swashing15369743swashing
tasking124616323_tasking
tasting84624213_tasting
tawsing1138673_tawsing
teasing83918513tea_sing
toasting93410583toasting
tossing83612563_tossing
trashing122613223trashing
trussing9268653trussing
unmasking1635263unmasking
vamoosing1543653vamoosing
vamosing1435593vam_osing
washing145119283_washing
wasting114422843_wasting
wissing113212943_wissing
wrassling1334273wrassling
yeasting12188923yeasting
yessing113210063_yessing

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.420425454.8
2DLD Change Limit1461622367.11020557.2
3Display Results2362360.0932537.6
 (SQL Overall)1786912367.62323441.0
 
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.