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

56 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
dispraise124834(None) 
dispraised1446401dispraised
dispraiser1345101dispraiser
dispraises1347391dispraises
dispraisers1443422dispraisers
disprize2048432dispr_ize
distraite10611472distraite
misraise10410522mis_raise
appraise1247703_appraise
despise1038683desp__ise
diapause1143893diap_ause
dioptase1145513diopta_se
diphase1387273di_pha_se
discase102912863dis_ca_se
disease83213843dis_ea_se
disgrace1248283disgra_ce
disgraces1348453disgraces
disguise1046833dis_guise
dishrags1346203dishrags_
disparage1346203disparage
disparages1446043disparages
disparate1249053disparate
disparity1546383disparity
disparts11109953disparts_
dispense11129783disp_ense
disperse111011353disp_erse
dispersive1645893dispersive
displace1348653displa_ce
displaces1448593displaces
displays1446293displays_
displease1245523displease
dispose10312753disp__ose
dispraising1546043dispraising
dispreads1346003dispreads_
disprized2247363dispr_ized
disprizes2148113dispr_izes
disprove14138193dispr_ove
disproves15158513disproves
disrate81418523dis_ra_te
disrates91118143dis_rates
disseise939853dis_seise
distrain9412243distrai_n
distrained1257663distrained
distrainer1146423distrainer
distrains10411333distrains
distraint101112903distraint
distrait9414343distrai_t
misparse1237733misp_arse
misphrase1644573misphra_se
mispoise1248263misp_oise
misprice1448133mispr_ice
misprize2147543mispr_ize
misraised1268313mis_raised
misraises1149933mis_raises
praise84419413___praise
upraise9158603__upraise

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.1561145455.1
2DLD Change Limit148641568.61017263.8
3Display Results56560.0461217.4
 (SQL Overall)178691568.81220278.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.