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

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

37 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
unprepossessing20763(None) 
prepossessing1862282__prepossessing
repossessing1553043___repossessing
prepossession1762284__prepossession
prepossessions1762294__prepossessions
dispossessing1661575__dispossessing
possessing1344675_____possessing
prepossess1443085__prepossess___
prepossessed1752205__prepossess_ed
prepossesses1552915__prepossess_es
preprocessing2053555__preprocessing
reassessing1243995___re_assessing
repossession1453095___repossession
repossessions1453075___repossessions
coprocessing1953576copr__o_cessing
derepressing1653576_derep__ressing
nonpossession1582066_n_onpossession
nonpossessions15111906_n_onpossessions
preblessing1643736__pre__blessing
precessing1598746__pre___cessing
prefocussing2052346__prefo_cussing
prestressing1583976__pre_stressing
processing15108186__pr__o_cessing
professing16106626__pr__o_fessing
progressing1545776__pr__ogressing
repossess1143706___repossess___
repossessed1452536___repossess_ed
repossesses1253346___repossess_es
repossessor1351806___repossess_or
repossessors1361686___repossessors
repressing13310396___rep__ressing
reprocessing1754696___reprocessing
uncrossing1345216uncr__o___ssing
undressing1246536undr_____essing
unpretending1672836unpre___tending
unprogressive1962506unpr__ogressive
unpromising1663626unpr__o__mising

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 Filter178691950240.356501941.0
2DLD Change Limit95024377.73612283.4
3Display Results37370.0132846.2
 (SQL Overall)178691378.10522047.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.