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

69 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
appraised144559(None) 
appraise1247701appraise_
appraisee1345971appraisee
appraiser1344951appraiser
appraises1347421appraises
apprised1337711appr_ised
appeased1335792appea_sed
appraisal1343632appraisal
appraisees1443152appraisees
appraisers1443502appraisers
appressed1445942appressed
apprise11310192appr_ise_
appriser1246782appr_iser
apprises12310962appr_ises
apprized2236542appr_ized
praised104214812__praised
reappraised1672822reappraised
upraised11167412_upraised
amortised1285813amortised
aphorised1546363aphorised
appalled1344813app_alled
appareled1442893appareled
appealed1335603appea_led
appeared1336143appea_red
appease1137913appea_se_
appeaser1245953appea_ser
appeases1238663appea_ses
appertained1653523appertained
appetiser1344443appetiser
applauded1542173applauded
applause1243663applause_
applauses1344033applauses
applied1247483app_li_ed
apposed1247853app__osed
appraisals1452673appraisals
appraising1545763appraising
appraisive1753203appraisive
apprisers1345053appr_isers
apprize2038183appr_ize_
apprizer2145463appr_izer
apprizes2137793appr_izes
approached2062363approached
approved16115073appr_oved
apyrase1236363apyra_se_
apyrases1337243apyra_ses
archaised1545483archaised
arrased8149863a_rra_sed
braised104014803__braised
dispraised1446403dispraised
misraised1268313misraised
oppressed1445123oppressed
outraised1039243outraised
phrased1387383_phra_sed
praise84419413__praise_
praiser93413943__praiser
praises94121103__praises
prised94322203__pr_ised
raised76120333___raised
reappraise1453323reappraise_
reappraises1553093reappraises
reprised112012203repr_ised
reraised9312353_reraised
sprained1138433_sprained
unraised91811883_unraised
upbraided1542963upbraided
upraise9158603_upraise_
upraiser10175843_upraiser
upraises10188473_upraises
vaporised15216953vapor_ised

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 Filter1786911486410.423422437.4
2DLD Change Limit148641696.10624343.4
3Display Results69690.0164312.5
 (SQL Overall)178691696.54527301.9
 
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.