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

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

47 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
indecentest145473(None) 
decentest1249082__decentest
indecenter1345022indecente_r
innocentest1353812innocentest
indecencies1655823indecencies_
indecent11411273indecen___t
indecently1655893indecent_ly
independent1554653independent
recentest11410283__recentest
abducentes1552084abducentes_
ancientest1255374an_cientest
cinquecentist26121294cinquecentist
decenter112412164__decente_r
decenters122410374__decenters
decentres12238524__decentres_
decongest1345634__decongest
detentes92712874__detentes_
detentist1049324__detentist
incenses102411004in__censes_
incented112412544in__cente_d
incenter102212094in__cente_r
incenters112510304in__centers
incents92414534in__cent_s_
indecency1745384indecen__cy
indefinites1553934indefinites_
indenes82916254ind__en_es_
indented101811734ind__ente_d
indenter92311444ind__ente_r
indenters102710034ind__enters
indents83114664ind__ent_s_
independents1653754independents
indicants1247204indicant_s_
indicates12312584indic_ates_
indigences14227324indigences_
indigenes11228994indigen_es_
indigents11208274indigent_s_
indolences1346574indolences_
inducement1546084induce_ment
inferences15410344inferences_
inherences1568964inherences_
innocences14106074innocences_
innocenter1252904innocente_r
innocents1145314innocent_s_
intensest949104in__tensest
irredentist1253814irredentist
undeceives1643864undeceives_
unevenest1247474un_even_est

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 Filter1786911488190.420425454.8
2DLD Change Limit148819478.34617831.2
3Display Results47470.0301566.7
 (SQL Overall)178691478.79620315.0
 
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.