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

242 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
ensuring931017(None) 
censuring1237601censuring
enduring10310011enduring
ensuing8239541ensu_ing
enuring8813881en_uring
insuring9311151insuring
assuring937772assuring
censoring1238782censoring
censusing1244812censusing
encoring11312172encoring
enduing9249722endu_ing
enquiring19175442enquiring
enserfing1345892enserfing
enshrine1147262enshrine
ensiling9410722ensiling
enskying1633282enskying
ensnaring1046382ensnaring
ensouling1046002ensouling
entering91920052entering
injuring1637472injuring
inuring81213012in_uring
measuring1236122measuring
reinsuring1146382reinsuring
tenuring938862ten_uring
tonsuring1046502tonsuring
unstring9312092unstring
venturing1337552venturing
abjuring1834883abjuring
adjuring1735103adjuring
alluring939073alluring
anearing9413973anearing
aneurin749833aneurin_
aneurins849073aneurins
angering102113803angering
anserine8313083anserine
answering1345803answering
assuming1135143assuming
auguring1036383auguring
bedspring1544313bedspring
censing104215263cens__ing
centering122915143centering
centring112112953cen_tring
closuring1255173closuring
clouring112811273clouring
coenduring1444233coenduring
coinsuring1345373coinsuring
conjuring1937913conjuring
consuming1437913consuming
curing94824783__curing
denaturing12115853denaturing
denuding1137113den_uding
desiring10312143desiring
detouring1136973detouring
devouring1435953devouring
disusing1039003disusing
during84419403__during
earing75235483e__aring
earring83519013e_arring
easing74926463eas__ing
easting84924303eas_ting
educing1137683e_ducing
effusing1534263effusing
eluding93412113e_luding
eluting84115293e_luting
embruing1344523embruing
enabling1138603enabling
enacting11311363enacting
enamoring1247033enamoring
enamouring1344293enamouring
encaging1258733encaging
encasing11610823encasing
encoding1239043encoding
endearing1139323endearing
ending83220253en__ding
enditing10311073enditing
endorsing1147303endorsing
endowing13178173endowing
endrin7312403en_drin_
endrins8312163en_drins
enduringly1553233enduringly
enfacing1467293enfacing
enforcing1545473enforcing
engaging1147373engaging
engining1039293engining
engirding1244153engirding
engorging1244873engorging
engulfing1443353engulfing
enisling949633enisling
enjoying1935003enjoying
enlacing1148773enlacing
enlarging1135803enlarging
enouncing1245583enouncing
enraging1049573enraging
enrobing1137433enrobing
enshrined1344523enshrined
enshrinee1244913enshrinee
enshrines1246583enshrines
enshrining1464613enshrining
ensign737523ens__ign
enslaving1345383enslaving
ensnarling1143223ensnarling
ensphering1644973ensphering
ensure63416003ensur__e
ensured83512943ensur_ed
ensurer73011903ensur_er
ensurers8279373ensurers
ensures73315903ensur_es
enthusing1355213enthusing
enticing11311803enticing
envying1435713en_vying
erring73816483e__rring
eserine7415903e_serine
espying1336193e_spying
esquiring19174023esquiring
essaying1235033essaying
estrin6315923e_strin_
estrins7315853e_strins
esurient849293e_surient
euchring1436613euchring
excusing1836503excusing
exhuming2143303exhuming
expiring1836253expiring
exserting1736663exserting
exuding16347443e_xuding
featuring1337323featuring
figuring1336283figuring
fissuring1344813fissuring
flouring123010143flouring
gendering12249753gendering
gesturing1136653gesturing
gnarring10225973gnarring
honouring1336883honouring
immuring1335533immuring
incurring1236873incurring
incurving1545373incurving
incusing1159953incusing
inducing1237873inducing
induing91910943indu_ing
infusing1237893infusing
inhering12913713inhering
inhuming1435853inhuming
inpouring1236393inpouring
inquiring19155643inquiring
inserting10914233inserting
inshrine1147483inshrine
insnaring1046313insnaring
insouling1036823insouling
inspiring1246183inspiring
insulin738483insulin_
insulins848863insulins
insulting1038053insulting
insurant8411413insurant
inurning937553in_urning
issuing836053issu_ing
knouting13226793knouting
knurling1344943kn_urling
lecturing1237303lecturing
lensing84015103lens__ing
louring83916503_louring
luring73820753__luring
lustring9269723lustring
manuring1139223manuring
maturing1139953maturing
mensing103915103mens__ing
mentoring1239543mentoring
misusing1138893misusing
muring95120373__muring
nearing83020333_nearing
nesting84320443nes_ting
nestling958893nestling
neurine7311683_neurine
nonjuring1756053nonjuring
nuking113411253_n_uking
nurling84215823_n_urling
nursing84012553_n_ursing
obscuring1444023obscuring
pasturing1238433pasturing
perduring1336013perduring
perjuring1944923perjuring
pleasuring1343503pleasuring
posturing1238993posturing
pouring103115863_pouring
pressuring1346513pressuring
reassuring1155943reassuring
reinjuring1844423reinjuring
renaturing11176803renaturing
rendering112213183rendering
repouring12310073repouring
respring111614063respring
restring91518783restring
resuming11310083resuming
resurging1138613resurging
scouring112810853scouring
securing11310413securing
sensating1039253sensating
sensing84116953sens__ing
sering74731813__sering
siring75128313__siring
snaring83920953sn_aring
sneering93414503sneering
snoring83917203sn_oring
snouting92511923snouting
soring74731883__soring
souring83219063_souring
spring94526013__spring
string75327563__string
subring104116263__subring
suing65026363__su_ing
surfing112914483__surfing
surging93115433__surging
suturing9310373suturing
tendering112210813tendering
tensing84616653tens__ing
tentering102313203tentering
texturing1735223texturing
touring82915193_touring
treasuring1144703treasuring
uncaring11312843uncaring
uncurbing1455513uncurbing
uncurling1237113uncurling
undaring10412753undaring
unerring9311273unerring
unfurling1335763unfurling
unsaying1288153unsaying
unseeing988293unseeing
unsewing1287433unsewing
unsexing1686853unsexing
unsling8313643uns_ling
unsparing1237713unsparing
unsprung1143173unsprung
unstrings1046013unstrings
unstrung954653unstrung
unsung736983unsu__ng
untiring9312003untiring
untuning937943untuning
upspring1335703upspring
upsurging1343353upsurging
usurping1134163_usurping
veluring1237563veluring
veneering1337663veneering
vesturing1337203vesturing
visoring1238373visoring

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 Limit1461622427.32619951.1
3Display Results2422420.1102200.0
 (SQL Overall)1786912427.85922737.1
 
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.