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

84 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
displays144629(None) 
display1336661display_
misplays1555541misplays
airplays1344532airplays
dismays13237432dis_mays
displace1348652displace
displaces1448592displaces
displant11412222displant
displants1248072displants
displayed1645882displayed
displayer1545832displayer
displayers1654822displayers
mislays12349242mis_lays
misplans1238862misplans
misplay1436382misplay_
redisplays1651592redisplays
splays114910872__splays
airplay1245483airplay_
byplays1743103_byplays
delays104014053d__elays
deploys1336523d_eploys
diddleys14334633diddleys
dimples122813213dimpl_es
dimply14339743dimpl_y_
diploes101111493di_ploes
dipsas9359893di_psa_s
disarrays1343513disarrays
disbars10310323dis_bars
disclaim1345643disclaim
disclaims1444853disclaims
disemploys1852133disemploys
dishpans14115833dishpans
dishrags1346203dishrags
dismals102010243dis_mals
dismay12229473dis_may_
disobeys1443683disobeys
dispart101115283disp_art
disparts11109953disparts
dispels10310503disp_els
dispends12308533dispends
displaced1546793displaced
displacer1446433displacer
displacers1545013displacers
displaying1746313displaying
displease1245523displease
displeases1345683displeases
displode1247643displode
displodes1347863displodes
displume1344803displume
displumes1444983displumes
disports111111113disports
disposals1245893disposals
disposes11313823disposes
dispraise1248343dispraise
dispreads1346003dispreads
disputes1139653disputes
disseats93211503disseats
downplays1842503downplays
endplays14123773endplays
fishways2043643fishways
gunplays1442713gunplays
inlays9389873_i_nlays
misclass1246833misclass
mislay113510683mis_lay_
misplace1437553misplace
misplaces1537953misplaces
misplan1147773mispla_n
misplant12410753misplant
misplants1347313misplants
misplayed1745303misplayed
mispleads1444203mispleads
missays124010253mis_says
nonplays1344893nonplays
outplays13246843outplays
plays106320773___plays
redisplay1552173redisplay_
replays12399763_replays
resprays1344713resprays
slays85723683__s_lays
spays105520513__sp_ays
splats84817303__splats
splay105816043__splay_
sprays115913643__sprays
virelays1444643virelays

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162846.58022213.1
3Display Results84840.0302800.0
 (SQL Overall)178691846.76626410.1
 
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.