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

104 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
insouling103682(None) 
ensouling1046001ensouling
inpouring1236392inpouring
insculping1542892insculping
insulin738482ins_ulin_
insulins848862ins_ulins
insulting1038052ins_ulting
insuring9311152ins_uring
assoiling1045353assoiling
befouling1534983befouling
biofouling1641823biofouling
consoling12310873conso_ling
ennobling1244123ennobling
enrolling1087733enrolling
ensiling9410723ens_iling
ensuing8239543ens_u_ing
ensuring9310173ens_uring
entoiling1038483entoiling
fouling113315373__fouling
inbounding1443843inbounding
including1344993including
incoming1349863inco_ming
incusing1159953in_cusing
indorsing1137143indorsing
indowing13198083indo_wing
inducing1237873in_ducing
induing91910943in_du_ing
indulging1244773in_dulging
indulin838773in_dulin_
induline939493in_duline
indulins958863in_dulins
infalling1356243infalling
infolding1445413infolding
informing1537023informing
infusing1237893in_fusing
ingoing9311023ingo__ing
ingoting1039863ingo_ting
ingulfing1443873in_gulfing
inhaling1239523in_haling
inholding1445113inholding
inhuming1435853in_huming
injuring1637473in_juring
inkling122911303in__kling
inpourings1342443inpourings
inscrolling1452443inscrolling
inserting10914243inserting
insetting1079283insetting
insisting1038823insisting
insnaring1046313insnaring
insolating1149153insolating
insolent81311553inso_lent
insouciant1253723insouciant
insoul638463insoul___
insouled936113insoul_ed
insouls737213insoul__s
inspiring1246183inspiring
installing1146403installing
instating10812213instating
instilling1145803instilling
insulant849883ins_ulant
insulating1139263ins_ulating
intitling1037213intitling
intituling1144443intituling
intombing1444613intombing
intoning9311123into_ning
intorting10311413intorting
intruding1146873intruding
inulin6311733in__ulin_
inulins7311493in__ulins
inuring81213013in__uring
invoicing1545333invoicing
invoking1635653invo_king
involuting1444613involuting
involving1644363involving
inwalling1385633inwalling
isling71213883i_s__ling
isocline1047293i_socline
isoline7314013i_so_line
issuing836053i_ssu_ing
knolling13206893kn_olling
knouting13226793kn_outing
misruling1237493misruling
noodling10209443_noodling
resoling92916303reso_ling
snooling93013473sn_ooling
snoozling19314343snoozling
snouting92511923sn_outing
soiling83422323__soiling
soling74226823__so_ling
souping104215533__souping
souring83219063__souring
sousing83517823__sousing
tinseling1036643tins_eling
tinselling1145523tinselling
uncoiling1238993uncoiling
uncoupling1544463uncoupling
undoubling14133433undoubling
unhousing1335883unhousing
unrolling1078563unrolling
unsealing10711043unsealing
unselling10810333unselling
unsling8313643uns__ling
unsmiling1256873unsmiling
unspooling1343853unspooling

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411046.81321817.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.28224538.7
 
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.