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

248 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
insuring931115(None) 
ensuring9310171ensuring
injuring1637471injuring
inuring81213011in_uring
assuring937772assuring
censuring1237602censuring
coinsuring1345362coinsuring
enduring10310012enduring
ensuing8239542ensu_ing
enuring8813882en_uring
fissuring1344812fissuring
immuring1335532immuring
incurring1236872incurring
incurving1545372incurving
incusing1159952incusing
inducing1237872inducing
induing91910942indu_ing
infusing1237892infusing
inhering12913702inhering
inhuming1435852inhuming
inpouring1236392inpouring
inquiring19155642inquiring
inserting10914232inserting
inshrine1147482inshrine
insnaring1046312insnaring
insouling1036822insouling
inspiring1246182inspiring
insulin738482insulin_
insulins848862insulins
insulting1038052insulting
insurant8411412insurant
inurning937552in_urning
issuing836052issu_ing
reinsuring1146382reinsuring
tonsuring1046502tonsuring
unstring9312092unstring
abjuring1834873abjuring
adjuring1735093adjuring
alluring939073alluring
anearing9413973anearing
aneurin749823aneurin_
aneurins849063aneurins
angering102113803angering
anserine8313083anserine
answering1345803answering
assuming1135143assuming
auguring1036383auguring
binturong12112073binturong
censoring1238783censoring
censusing1244813censusing
cincturing1554253cincturing
cindering13311213cindering
closuring1255173closuring
clouring112811273clouring
conjuring1937903conjuring
consuming1437913consuming
curing94824783__curing
desiring10312143desiring
disusing1039003disusing
during84419403__during
encoring11312173encoring
enduing9249723endu_ing
enquiring19175443enquiring
enserfing1345893enserfing
enshrine1147263enshrine
ensiling9410723ensiling
enskying1633283enskying
ensnaring1046383ensnaring
ensouling1046003ensouling
entering91920053entering
figuring1336283figuring
fingering1439183fingering
flouring123010143flouring
gesturing1136653gesturing
gingering1238863gingering
gnarring10225973gnarring
hindering14310263hindering
honouring1336883honouring
ignoring1036483ignoring
illuding1035803illuding
illuming1135873illuming
imbruing1344003imbruing
imbuing1236103imbu_ing
imputing1336853imputing
inarming1138343inarming
inbeing1038333in_being
incaging1288673incaging
incasing11610603incasing
inching134414323in_ching
incising11411093incising
inciting11312533inciting
including1344993including
incoming1349863incoming
indexing1737113indexing
inditing10312113inditing
indorsing1137143indorsing
indowing13198083indowing
inducting1338373inducting
indulging1244773indulging
indulin838773indulin_
induline939493induline
indulins958853indulins
indurating1249243indurating
inferring1338613inferring
infirming1545163infirming
infixing1936103infixing
informing1537023informing
infringe1245083in_fringe
ingoing9311023in_going
ingoting1039863ingoting
ingulfing1443873ingulfing
inhaling1239523inhaling
injuries1567673injuries
inking115119053in__king
inkling122911303in_kling
inlacing1158373inlacing
inlaying1247893inlaying
inlying1168153in_lying
innerving1346493innerving
inning73617633in__ning
inpourings1342433inpourings
inputting1235823inputting
inrushing1365503inrushing
inscribe1245693inscribe
inscribing1543853inscribing
insculping1542893insculping
insetting1079283insetting
inshrined1344423inshrined
inshrines1246533inshrines
inshrining14104583inshrining
insisting1038813insisting
insphering1644193insphering
instarring1144063instarring
instating10812213instating
insulant849873insulant
insulating1139263insulating
insurance1147443insurance
insurants947643insurants
insure63416603insur__e
insured83714253insur_ed
insureds9277613insureds
insurer73312803insur_er
insurers83710133insurers
insures73117263insur_es
insurgent1046543insurgent
interning10315253interning
interring10315423interring
intoning9311123intoning
intorting10311413intorting
intruding1146873intruding
intuiting1089613intuiting
inturn63411563intur_n_
inturns73210133intur_ns
inulin6311733in_ulin_
inulins7311493in_ulins
inurn53712863in_ur_n_
inurns63310983in_ur_ns
invading1336263invading
inversing1389623inversing
inverting131013223inverting
inviting1239733inviting
invoking1635653invoking
iring66025423i___ring
isling71213883i_s_ling
jointuring1843233jointuring
knouting13226793knouting
knurling1344943kn_urling
lingering11310503lingering
louring83916503_louring
luring73820753__luring
lustring9269723lustring
mainspring1553793mainspring
manuring1139223manuring
maturing1139953maturing
measuring1236123measuring
minoring11311463min_oring
minuting1139723min_uting
misusing1138893misusing
muring95120373__muring
nearing83020333_nearing
neurine7311683_neurine
nidering10510473nidering
nonjuring1756043nonjuring
nuking113411253_n_uking
nurling84215823_n_urling
nursing84012553_n_ursing
obscuring1444023obscuring
pasturing1238433pasturing
picturing1436033picturing
posturing1238993posturing
pouring103115863_pouring
reinjuring1844423reinjuring
respring111614063respring
restring91518783restring
resuming11310083resuming
resurging1138613resurging
rinsing82516113rins__ing
scouring112810853scouring
securing11310413securing
sering74731813__sering
sintering101014793sintering
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
tenuring938863tenuring
tincturing1343313tincturing
tinkering1437693tinkering
tinseling1036643tinseling
tissuing935103tissu_ing
touring82915193_touring
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
venturing1337553venturing
vesturing1337203vesturing
visoring1238373visoring
windsurfing1951393windsurfing
wintering13412353wintering

Search took 9 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.1701051123.5
2DLD Change Limit1461622488.06318127.5
3Display Results2482480.1401771.4
 (SQL Overall)1786912488.37321341.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.