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

51 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
redisplaying195179(None) 
displaying1746312__displaying
displacing1646413__displacing
misplaying1845553__misplaying
redeploying1842703red_eploying
redisplay1552173redisplay___
redisplayed1851613redisplay_ed
redisplays1651593redisplay__s
redisposing1543443redisp_osing
replaying15259603re___playing
respraying1636093re__spraying
bedimpling1862464bedimpl__ing
dismaying1656824__dis_maying
displanting1546044__displanting
displeasing1544934__displeasing
disploding1575874__disploding
displuming1644374__displuming
endplaying1742764_e_ndplaying
legislating1343404legis_lating
mislaying1557914__mis_laying
misplacing1745914__misplacing
predisposing1852624predisp_osing
reapplying1843024re_appl_ying
redialing11311844redi___aling
redialling1246204redi_al_ling
redictating1546804redi_ctating
redipping1555594redi_p__ping
rediscussing1661844rediscussing
redissolving1751434redissolving
redistilling1453304redistilling
reemploying1952834re_employing
reenslaving1552474reens_laving
reimplanting1752624re_implanting
reinflaming1743164re_inflaming
reinflating1545994re_inflating
relaying122515154re____laying
repaying142712394re___p_aying
replacing142210164re___placing
replating122217404re___plating
replying14269404re___pl_ying
resaying122512454re__s__aying
reslating102516994re__s_lating
respacing1438894re__sp_acing
respading1338804re__sp_ading
respeaking1736804re__speaking
resplicing1546294re__splicing
resupplying1951374resuppl_ying
reticulating1546394reticulating
reviolating1556254revi_olating
splaying14219304____splaying
underplaying19154354underplaying

Search took 8 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 Filter1786911247900.393454684.5
2DLD Change Limit124790517.34316994.4
3Display Results51510.0133923.1
 (SQL Overall)178691517.74923059.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.