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

74 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
apprising144796(None) 
appraising1545761appraising
apprizing2347191apprizing
aphorising1645742aphorising
appeasing1446342appeasing
appetising1544512appetising
apposing1337402app_osing
approving1745052approving
arising83619972a__rising
prising103321452__prising
reprising12312552reprising
uprising1138952_uprising
vaporising1645702vaporising
abscising1444943abscising
advising1336153a_dvising
agonising1146573agonising
amortising1345973amortising
aphorizing2546473aphorizing
appalling1444923appalling
appareling1543423appareling
appealing1446493appealing
appearing1436893appearing
appending1536283appending
appetizing2445403appetizing
applying1634653app_lying
appointing1545323appointing
appraisingly2051873appraisingly
appraisive1753203appraisive
apprise11310193appris__e
apprised1337713appris_ed
appriser1246783appris_er
apprisers1345053apprisers
apprises12310963appris_es
aproning11311793a_proning
arriving1237363a_rriving
ascribing1444953ascribing
aspersing1237603aspersing
aspiring1138873asp_iring
atomising1247993atomising
attriting1048683attriting
azotising1945293azotising
baptising1446093baptising
comprising1748633comprising
depriving1636403depriving
irising83614423__irising
opposing1336383opp_osing
oppressing1545973oppressing
parsing103819553_par_sing
peising103416763__peising
periling11316863_periling
perishing1539533_perishing
perusing11811063_perusing
phrasing1438013_phrasing
poising103617103__poising
praising113214563_praising
pricing123417343__pricing
priding113317543__priding
priming123417373__priming
prissing113011453__prissing
prizing193514683__prizing
prosing103319383__prosing
pursing103715553_pur_sing
reappraising1762843reappraising
repricing14310473repricing
rerising93017783_rerising
rising74025883___rising
satirising1146663satirising
spiriting1238413spiriting
surprising1345623surprising
uppiling1335853upp_iling
upraising1237263upraising
uprisings1243343_uprisings
valorising1445303valorising
vaporizing2556493vaporizing

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641748.08018396.2
3Display Results74740.0302466.7
 (SQL Overall)178691748.28021581.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.