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

86 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
insnaring104631(None) 
ensnaring1046381ensnaring
ensnarling1143222ensnarling
inspiring1246182inspiring
instarring1144062instarring
instating10812212instating
insuring9311152ins_uring
snaring83920952__snaring
unsnarling1143912unsnarling
unsparing1237712unsparing
anearing9413973an_earing
answering1345803answering
endearing1139323endearing
enslaving1345383enslaving
ensuring9310173ens_uring
ignoring1036483i_gnoring
inarming1138343i__narming
incaging1288673in_caging
incanting1289903incanting
incasing11610603in_casing
incurring1236873incurring
inferring1338613inferring
inflaming1546263inflaming
inflating13310443inflating
inhaling1239523in_haling
inhering12913713in_hering
injuring1637473in_juring
inlacing1158373in_lacing
inlaying1247893in_laying
innerving1346503in_nerving
inning73617633in_n__ing
inpouring1236393inpouring
inquiring19155643inquiring
inserting10914243inserting
insetting1079283insetting
inshrine1147493ins_hrine
insinuating1244533insinuating
insisting1038823insisting
insnare748243insnar__e
insnared956123insnar_ed
insnarer865303insnar_er
insnarers954433insnarers
insnares858083insnar_es
insolating1149153insolating
insouling1036823insouling
inspanning1343203inspanning
insphering1644193insphering
installing1146403installing
instancing1344643instancing
insulating1139263insulating
insulting1038053insulting
inswathing1742973inswathing
interring10315423interring
intonating1148633intonating
inundating1244543inundating
inuring81213013i__nuring
invading1336263in_vading
inweaving1644773inweaving
misnaming1447423misnaming
nearing83020333_n_earing
scaring103421973__scaring
searing83330923__searing
sharing113723243__sharing
snaking123915303__snaking
snarfing12358663__snarfing
snarling92513183__snarling
snawing113612483__snawing
snoring83917203__snoring
soaring83521893__soaring
sparing104823873__sparing
staring84527053__staring
unbearing1239353unbearing
uncaring11312843un_caring
undaring10412753un_daring
unfearing1338883unfearing
unsaying1288153uns_aying
unsealing10711043unsealing
unseaming1278113unseaming
unseating10713203unseating
unsnagging1342953unsnagging
unsnapping1542933unsnapping
unstating10711213unstating
unstring9312093uns_tring
unswearing1444413unswearing
upsoaring1244513upsoaring
upstaring1235963upstaring

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 Filter1786911486410.436409841.7
2DLD Change Limit148641866.45323034.4
3Display Results86860.0461869.6
 (SQL Overall)178691866.93525766.5
 
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.