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

199 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
assuring93777(None) 
assuming1135141assuming
abjuring1834882abjuring
adjuring1735102adjuring
alluring939072alluring
aspiring1138872aspiring
assaying1236002assaying
asserting1038662asserting
assorting1037302assorting
assuaging1144122assuaging
auguring1036382auguring
ensuring9310172ensuring
fissuring1344812fissuring
insuring9311152insuring
issuing836052issu_ing
pasturing1238432pasturing
reassuring1155942reassuring
souring83219062_souring
abducing1474063abducing
absorbing1444483absorbing
abusing1049113a_busing
accruing1344033accruing
accusing1336783accusing
acquiring2144483acquiring
adducing1384113adducing
adhering1338883adhering
admiring1236133admiring
adoring9412523a_doring
adsorbing1344123adsorbing
airing74927503a__iring
alluding1036953alluding
altering91917113altering
amusing1039383a_musing
anearing9413973anearing
aneurin749833aneurin_
aneurins849073aneurins
angering102113803angering
anserine8313093anserine
answering1345803answering
arguing9248733argu_ing
armoring1149123armoring
armouring1244983armouring
arousing93811803arousing
ashing107824093a_s_hing
ashlaring1344493ashlaring
ashlering1344153ashlering
asking116017233a_s_king
aspersing1237603aspersing
aspirin937823aspirin_
aspirins1037733aspirins
asquint16208323asqu_int
assailing1036023assailing
assaulting1142923assaulting
assenting1038163assenting
assessing1045173assessing
assign736783ass__ign
assigning1144673assigning
assisting1046183assisting
assoiling1045353assoiling
assurance1145293assurance
assure6610773assur__e
assured858373assur_ed
assureds984493assureds
assurer767793assur_er
assurers866313assurers
assures7611403assur_es
assurgent1044623assurgent
assuror754203assur_or
assurors894043assurors
asswaging1443103asswaging
astringe938223a_stringe
attiring939483attiring
attuning935903attuning
auding83616933a__uding
averring12239063averring
basseting1236153basseting
capsuling1444533capsuling
capturing1436623capturing
censuring1237603censuring
closuring1255173closuring
clouring112811273clouring
coassuming1542653coassuming
curing94824783__curing
dayspring1642613dayspring
desiring10312143desiring
disusing1039003disusing
during84419403__during
enduring10310013enduring
ensuing8239543ensu_ing
enuring8813883_enuring
esquiring19174023esquiring
essaying1235033essaying
favouring1644023favouring
figuring1336283figuring
flouring123010143flouring
gassing94216333gass__ing
gesturing1136653gesturing
hachuring1845123hachuring
hamstring1546003hamstring
hassling1236803hass_ling
immuring1335533immuring
injuring1637473injuring
inuring81213013_inuring
kashering1736253kashering
labouring1236213labouring
lassoing946383lass_oing
louring83916503_louring
luring73820753__luring
lustring9269723lustring
manuring1139223manuring
massacring1543593massacring
massaging1346353massaging
massing104318023mass__ing
mastering122315303mastering
maturing1139963maturing
measuring1236123measuring
misusing1138893misusing
muring95120373__muring
obscuring1444023obscuring
passaging1345613passaging
passerine1147083passerine
passing104318423pass__ing
pastoring12310853pastoring
posturing1238993posturing
pouring103115863_pouring
preassuring1443823preassuring
pressuring1346513pressuring
rapturing1245363rapturing
rassling939013rass_ling
reassuming1343703reassuming
respring111614063respring
restring91518783restring
resuming11310083resuming
resurging1138613resurging
sabering112113743sabering
sabring102614843_sabring
sacring103115983_sacring
saluting9310553saluting
sashing114621473sas_hing
sassing84615553sas_sing
saucing10311003_saucing
savoring1269483savoring
savouring1335193savouring
scaring103421973_scaring
scoring103117213_scoring
scouring112810853scouring
searing83330923_searing
securing11310413securing
sering74731813__sering
sharing113723243_sharing
shoring112820073_shoring
shuting113212053_shuting
siring75128313__siring
sluing74315883_slu_ing
slurping11278123_slurping
slurring9288833_slurring
snaring83920953_snaring
snoring83917203_snoring
soaring83521893_soaring
soring74731883__soring
souping104215533_souping
sourcing1158353_sourcing
sousing83517823_sousing
sparing104823873_sparing
spiring103918183_spiring
sporing104319413_sporing
spring94526013__spring
spuing94313363_spu_ing
spuming1248523_spuming
spurning11258663_spurning
spurring11339763_spurring
spurting113111633_spurting
squaring18158633_squaring
squiring18177563_squiring
staring84527053_staring
storing83921123_storing
string75327563__string
subring104116263_subring
suing65026363__su_ing
surfing112914483__surfing
surging93115433__surging
sussing84013703_sussing
suturing9310373suturing
tabouring1245723tabouring
tasseling1035853tasseling
tenuring938863tenuring
tissuing935103tissu_ing
tonsuring1046503tonsuring
touring82915193_touring
unassuming1341923unassuming
unstring9312093unstring
upspring1335703upspring
upsurging1343353upsurging
ushering1258923ushering
usurping1134163_usurping
vapouring1544653vapouring
veluring1237563veluring
vesturing1337203vesturing
visoring1238373visoring

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621996.40622816.4
3Display Results1991990.0932139.8
 (SQL Overall)1786911996.93925751.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.