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

76 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
insolent8131155(None) 
indolent91311681indolent
insolents9137521insolents
insolvent12136121insolvent
innocent1048162innocent
insole63515862insole__
insolence1147192insolence
insolently1355582insolently
insoles73516242insole_s
insolvents13114302insolvents
insulant849872insulant
unsilent849602unsilent
absolvent1454093absolvent
cholent12313253_cholent
condolent1249833condolent
dissolvent1454573dissolvent
enrolment1148473enrolment
gasolene945553gasolene
idiolect1144353idiolect
impotent1249533impotent
incent83320723in__cent
incident11410203incident
indecent11411273indecent
indent73021243in__dent
indigent102911613indigent
indole74516053indole__
indolence1246773indolence
indolently1465123indolently
indoles83716363indole_s
indulgent1145223indulgent
inflect1249223in_flect
influent1147623influent
inhalant1147393inhalant
inherent11412793inherent
inlet53732403in__le_t
innocents1145313innocents
insanest8410343insanest
insect83916583ins__ect
insert64325253ins__ert
inset54430863ins__e_t
insistent948253insistent
insolate8311893insolate
insolences1247113insolences
insolvency1852873insolvency
insouled936113insoule_d
insouling1036823insouling
inspect1138463ins_pect
instalment1245373instalment
instant7815343ins_tant
insulants946913insulants
insulin738483insulin_
insulins848863insulins
insult62813673insul__t
insurant8411413insurant
insurgent1046543insurgent
inswept1245733ins_wept
intent63122773in__tent
interlent9416733interlent
intolerant1056133intolerant
invent93316363in__vent
inwoven13175523inwoven_
islet54527553i_s_le_t
isogeny11196363i_sogeny
isolead835183i_solead
isoline7314013i_soline
nocent83217413_n_ocent
redolent9411883redolent
resolvent1246583resolvent
silent64125843__silent
sklent103614353__sklent
solvent10310833__solvent
splent84720193__splent
unsent63820963uns__ent
unspent92610893uns_pent
violent102110813_violent
winsomest1444333winsomest

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.1731032896.0
2DLD Change Limit146162767.36019859.0
3Display Results76760.0302533.3
 (SQL Overall)178691767.56323627.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.