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

63 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
unsilent84960(None) 
insolent81311552insolent
silent64125842__silent
unsent63820962uns__ent
unspent92610892uns_pent
ancient9514733anci_ent
antileft1149993antileft
basilect1245903basilect
desinent9312963desinent
ensile62616473ensile__
ensiled82611433ensile_d
ensiles72714833ensile_s
ensiling9410723ensiling
incident11410203incident
indigent102911613indigent
indolent91311683indolent
insistent948253insistent
insolents9137523insolents
insolvent12136123insolvent
insulant849883insulant
muniment1248943mun_iment
pestilent1148843pestilent
resident9313753resident
resilient9410113resilient
sileni63312143__sileni
silents73514493__silents
sklent103614353__sklent
splent84720193__splent
unbent83216593un__bent
unblest9411813un_blest
uncleft1257493un_cleft
undulant946823undulant
unguent839123un_guent
univalent1245653univalent
unkent103116053un__kent
unlet54133333un__le_t
unoiled82415483unoile_d
unpent83117373un__pent
unpile81914323unpile__
unpiled102312743unpile_d
unpiles92112783unpile_s
unpiling1139753unpiling
unpliant1047143unpliant
unrent63219783un__rent
unripest1046083unripest
unrisen7229283unrisen_
unseat64221023uns__eat
unseen62012623uns_een_
unset54532433uns__e_t
unsight1137483unsi_ght
unsigned1037563unsigned
unsized172510543unsize_d
unsling8313643uns_ling
unslung844563uns_lung
unsmiling1256873unsmiling
unsoiled92412083unsoile_d
unspilt938853unspil__t
unsplit956563unspl_it
unswept1246013uns_wept
unwisest1165123unwisest
upsent83314063ups__ent
upsilon943583upsilon_
upsilons1043173upsilons

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 Filter1786911461620.420425454.8
2DLD Change Limit146162636.42322756.0
3Display Results63630.0331909.1
 (SQL Overall)178691636.87625987.6
 
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.