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

125 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
insnares85808(None) 
ensnares856891ensnares
insnare748241insnare_
insnared956121insnared
insnarer865301insnarer
insnarers954431insnarers
ensnare767122ensnare_
ensnared965292ensnared
ensnarer874472ensnarer
ensnarers983572ensnarers
ensnarls873392ensnarls
infares10313022in_fares
innages82911302in_nages
innards837152in_nards
inscapes1237812inscapes
inspires1037622inspires
instars7411132instar_s
instates81615832instates
insures73117262ins_ures
snares65329032__snares
unsnarls894882unsnarls
annates72415423an_nates
enslaves1136393enslaves
ensnarl784913ensnar_l
ensnarled1042913ensnarled
ensures73315903ens_ures
ignores8269003i_gnores
inanes62519803i__nanes
inarms8410093i__narms
inboards1145843inboards
incages103013883in_cages
incases93615973in_cases
infantes11249633infantes
infare9313083in_fare_
inflames1377323inflames
inflates11512193inflates
infrared1236193infrared
infrareds1342583infrareds
ingates82716913in_gates
ingrates9514173ingrates
inhales10511863in_hales
inheres10315173in_heres
injures143111173in_jures
inlaces92512903in_laces
inmates92715783in_mates
innage73011573in_nage_
innate63917313in_nate_
inners63919353in_ner_s
innerves1158013in_nerves
inquires17237363inquires
insane6314893ins_ane_
insaner7310443ins_aner
insanest8410343ins_anest
inscape1138023inscape_
inseams9307903insea_ms
inserts74013993ins_erts
inshore1038723inshore_
insiders947763insiders
insides8512653ins_ides
insinuates1045463insinuates
insnaring1046313insnaring
insolates9311273insolates
insoles73516243ins_oles
inspans937803inspa_ns
inspheres1455403inspheres
inspire938253inspire_
inspired1136273inspired
inspirer1045183inspirer
inspirers1143963inspirers
installs858923installs
instals7611713insta_ls
instances1148753instances
instants8910153instants
instar6310013instar__
instarred1043963instarred
instate71616483instate_
instated91613343instated
insulars8137323insular_s
insulates9311843insulates
insure63416603ins_ure_
insured83714253ins_ured
insureds9277613ins_ureds
insurer73312803ins_urer
insurers83710133ins_urers
inswathes1543953inswathes
intakes11310943in_takes
intonates9410243intonates
inulases838763inulases
inundates1045773inundates
inures63318953i__nures
invades11118293in_vades
invars9310003in_var_s
inwards1138343in_wards
inweaves1445043inweaves
ironwares1244553ironwares
isobares1046513isobares
kingsnakes14251753kingsnakes
misnames12119883misnames
nares55544153___nares
nonages8313843_nonages
nonarts7311303_nonarts
pinnaces12268863pin_naces
scares85033003__scares
shares95236413__shares
snakes103919603__snakes
snare54429983__snare_
snared74824553__snared
snarer64620843__snarer
snarers74216663__snarers
snarfs95113423__snarfs
snarks104815733__snarks
snarls64016873__snarls
snores64324323__snores
spares84834553__spares
stares66038753__stares
tinwares1137913tin_wares
unawares1137053unawares
unseared91113943unseared
unshared121510703unshared
unsnags835463unsna_gs
unsnaps935423unsna_ps
unsnarl7107153unsnar_l
unsnarled1035743unsnarled
unstates81314993unstates
upstares10178583upstares

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.440406115.9
2DLD Change Limit1461621257.12320519.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.60923484.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.