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 “insnarer” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
insnarer86530(None) 
ensnarer874471ensnarer
insnare748241insnare_
insnared956121insnared
insnarers954431insnarers
insnares858081insnares
ensnare767122ensnare_
ensnared965292ensnared
ensnarers983572ensnarers
ensnares856892ensnares
insaner7310442ins_aner
inspirer1045182inspirer
insurer73312802ins_urer
snarer64620842__snarer
answerer1144273answerer
enslaver1144713enslaver
ensnarl784913ensnar_l
ensnarled1042913ensnarled
ensnarls873393ensnarls
ensurer73011903ens_urer
ignorer8276103i_gnorer
inaner62213543i__naner
infare9313083in_fare_
infares10313023in_fares
inferrer11217443inferrer
inflamer1356123inflamer
inflater1149893inflater
infrared1236193infrared
inhaler1068053in_haler
injurer14318473in_jurer
inlander937223inlander
inlayer1036933in_layer
innage73011573in_nage_
innages82911303in_nages
innards837153in_nards
innate63917313in_nate_
inner54920633in_n__er
inquirer17235173inquirer
insane6314893ins_ane_
inscape1138023inscape_
inscapes1237813inscapes
inserter82312133inserter
insetter8218593insetter
inshore1038723inshore_
insider849733ins_ider
insister888783insister
insnaring1046313insnaring
inspire938253inspire_
inspired1136273inspired
inspirers1143963inspirers
inspires1037623inspires
installer945013installer
instanter946243instanter
instar6310013insta__r
instarred1043963instarred
instars7411133instar_s
instate71616483instate_
instated91613343instated
instates81615833instates
insulter836883insulter
insure63416603ins_ure_
insured83714253ins_ured
insurers83710133ins_urers
insures73117263ins_ures
invader11146453in_vader
nearer64618893_n_earer
scarer84524613__scarer
searer65432023__searer
sharer95025483__sharer
snare54429983__snare_
snared74824553__snared
snarers74216663__snarers
snares65329033__snares
snarler73610633__snarler
snorer64316763__snorer
soarer64522243__soarer
sparer84524963__sparer
starer64027363__starer
unseared91113943unseared
unshared121510703unshared
unsnarl7107153unsnar_l
unsnarled1035743unsnarled
unsnarls894883unsnarls

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.436409841.7
2DLD Change Limit146162837.61019206.6
3Display Results83830.0302766.7
 (SQL Overall)178691838.07622126.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.