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

146 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
insnare74824(None) 
ensnare767121ensnare
insnared956121insnared
insnarer865301insnarer
insnares858081insnares
ensnared965292ensnared
ensnarer874472ensnarer
ensnares856892ensnares
ensnarl784912ensnarl
infare9313082in_fare
innage73011572in_nage
innate63917312in_nate
insane6314892ins_ane
insaner7310442insaner
inscape1138022inscape
inshore1038722inshore
insnarers954432insnarers
inspire938252inspire
instar6310012instar_
instars7411132instars
instate71616482instate
insure63416602ins_ure
snare54429982__snare
unsnarl7107152unsnarl
ansae55720973ans_a_e
ansate64517863ans_ate
enslave1036273enslave
ensnarers983573ensnarers
ensnarled1042913ensnarled
ensnarls873393ensnarls
ensure63416003ens_ure
ignore7269063i_gnore
inane52820343i__nane
inaner62213543inaner_
inarm7314423i__narm
inboard1037063inboard
incage93513623in_cage
incase83615283in_case
infante101910883infante
infares10313023in_fares
inflame1256963inflame
inflate10312313inflate
infrared1236193infrared
ingate73018243in_gate
ingrate8715123ingrate
inhale9411513in_hale
inhere9313713in_here
injure133410863in_jure
inlace82513043in_lace
inmate82917363in_mate
innages82911303in_nages
innards837153in_nards
inner54920633in_ner_
inners63919353in_ners
innerve1056753in_nerve
inphase1245383inphase
inquire16227993inquire
inscapes1237813inscapes
inseam8329993insea_m
inseams9307903inseams
insecure1044653insecure
insensate945393insensate
insert64325253ins_ert
inside7613453ins_ide
insider849733insider
insigne837673insigne
insincere1143683insincere
insinuate945963insinuate
insnaring1046313insnaring
insofar1043543insofar_
insolate8311893insolate
insole63515863ins_ole
inspan837513inspa_n
inspans937803inspans
insphere1355973insphere
inspired1136273inspired
inspirer1045183inspirer
inspires1037623inspires
instable10313203instable
instal6712193insta_l
install779363install
instals7611713instals
instance1049883instance
instant7815353instant
instarred1043963instarred
instated91613343instated
instates81615833instates
insular7138703insular_
insulars8137323insulars
insulate8312843insulate
insured83714253ins_ured
insurer73312803ins_urer
insures73117263ins_ures
inswathe1443693inswathe
intake10510863in_take
intonate8310923intonate
inulase739413inulase
inundate946043inundate
inure54119053i__nure
invade10157853in_vade
invar839513in_var_
invars9310003in_vars
inward10310333in_ward
inweave1344723inweave
ironware1144653ironware
isobare946343isobare
kingsnake13181813kingsnake
misname11119483misname
nonage7313683_nonage
nonart6319193_nonart
onshore10310013onshore
onstage838363onstage
pinnace113510313pin_nace
pinnae84414643pin_na_e
pinnate93613743pin_nate
scare75334463__scare
share86437083__share
snake94821113__snake
snared74824553__snared
snarer64620843__snarer
snares65329033__snares
snarf86525423__snarf
snark95419943__snark
snarl54921083__snarl
snore55424953__snore
spare75135563__spare
stare54440263__stare
sware85828213__sware
tinware1038603tin_ware
unaware1038033unaware
unsafe9310693uns_afe
unseared91113943unseared
unshared121510703unshared
unsharp1235543unsharp
unsmart939603unsmart
unsnag736393unsna_g
unsnags835463unsnags
unsnap836203unsna_p
unsnaps935423unsnaps
unsnarled1035743unsnarled
unsnarls894883unsnarls
unstate71916213unstate
unsure62815413uns_ure
unswore1039053unswore
upstare9158683upstare
zingare1737143zin_gare

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271466.11021935.7
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.56227231.2
 
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.