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

139 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
insnared95612(None) 
ensnared965291ensnared
insnare748241insnare_
insnarer865301insnarer
insnares858081insnares
ensnare767122ensnare_
ensnarer874472ensnarer
ensnares856892ensnares
ensnarled1042912ensnarled
infrared1236192infrared
insnarers954432insnarers
inspired1136272inspired
instarred1043962instarred
instated91613342instated
insured83714252ins_ured
snared74824552__snared
unseared91113942unseared
unshared121510702unshared
unsnarled1035742unsnarled
aneared8512743an_eared
ansated84214003ans_ated
answered1235493answered
ascared10399523_ascared
endeared1038053endeared
enslaved1245063enslaved
ensnarers983573ensnarers
ensnarl784913ensnar_l
ensnarls873393ensnarls
ensured83512943ens_ured
ignored9226443i_gnored
inarmed10268673i__narmed
inboard1037063inboar_d
inbred93010403i__nbred
incaged114010443in_caged
incanted11259543incanted
incased103612393in_cased
incurred1136493incurred
infare9313083in_fare_
infares10313023in_fares
inferred12248353inferred
inflamed1446033inflamed
inflated12410863inflated
infrareds1342583infrareds
inhaled1169333in_haled
inhered11313163in_hered
injured15339063in_jured
inlaced10239873in_laced
innage73011573in_nage_
innages82911303in_nages
innards837153in_nards
innate63917313in_nate_
inned64118423in_n__ed
innerved1246293in_nerved
inpoured1135813inpoured
inquired18245933inquired
insane6314883ins_ane_
insaner7310443ins_aner
inscape1138013inscape_
inscapes1237813inscapes
inserted92413053inserted
insetted9249023insetted
inshore1038723inshore_
insinuated1144813insinuated
insisted998673insisted
insnaring1046313insnaring
insolated1039713insolated
insouled936113insouled
inspanned1242853inspanned
insphered1564783insphered
inspire938253inspire_
inspirer1045183inspirer
inspires1037623inspires
installed1045843installed
instanced1245693instanced
instar6310013instar__
instars7411133instar_s
instate71616483instate_
instates81615833instates
insulated10310713insulated
insulted937193insulted
insure63416603ins_ure_
insureds9277613ins_ureds
insurer73312803ins_urer
insures73117263ins_ures
inswathed1642963inswathed
interred92615263interred
intonated1048303intonated
inundated1144753inundated
inured73114813i__nured
invaded12127043in_vaded
inward10310333in_war_d
inweaved1534193inweaved
misnamed13127593misnamed
neared75119803_n_eared
pinnated11338553pin_nated
scared95227293__scared
seared75232843__seared
shared105829063__shared
snaked115017593__snaked
snare54429983__snare_
snarer64620843__snarer
snares65329033__snares
snarfed11378753__snarfed
snarled83612363__snarled
snawed104813733__snawed
snored74819543__snored
soared74324293__soared
spared95427493__spared
stared75429873__stared
unbeared111611653unbeared
unfeared121511013unfeared
unnamed102410273un_named
unsated83419933uns_ated
unsaved113312193uns_aved
unsawed112911503uns_awed
unscaled111410113unscaled
unscarred1235673unscarred
unsealed91513623unsealed
unseamed111210663unseamed
unseated91317683unseated
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshaved15157733unshaved
unslaked1338463unslaked
unsnagged1243123unsnagged
unsnapped1443983unsnapped
unsnarl7107153unsnar_l
unsnarls894883unsnarls
unsoaked1338853unsoaked
unsoured9310063unsoured
unsquared1944073unsquared
unstarred1036363unstarred
unstated91615813unstated
unstayed12168393unstayed
unswayed15155713unswayed
upsoared11154353upsoared
upstared11156573upstared
vinegared1442963vinegared

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 Limit1461621397.48619524.7
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.96922423.3
 
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.