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 “display” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
display133666(None) 
displays1446291displays
misplay1436381misplay
airplay1245482airplay
dimply14339742dimpl_y
dismay12229472dis_may
displace1348652displace
displant11412222displant
displayed1645882displayed
displayer1545832displayer
mislay113510682mis_lay
misplan1147772misplan
misplays1555542misplays
redisplay1552172redisplay
splay105816042__splay
airplays1344533airplays
byplay1634193_byplay
crisply14426523crispl_y
damply14337893dampl_y
deeply1257013deepl_y
delay94820633d__elay
deploy1237583d_eploy
diddley13388103diddley
diddly12389573diddl_y
dilly94923783di__lly
dimly114913483di_ml_y
dimple113512793dimpl_e
dimpled132810303dimpled
dimples122813213dimples
dinkly144311083dinkl_y
diplex16408053di_plex
diploe9810153di_ploe
dipody1336363di_pody
dipolar1056853dipolar
dippy135111543di_p_py
dipsas9359893di_psas
direly10311563direl_y
disarray1244833disarray
disbar938513dis_bar
disclaim1345643disclaim
disemploy1752563disemploy
dishpan13105523dishpan
dishrag1246273dishrag
dishy125712353dis__hy
dismal92412243dis_mal
dismally1446513dismally
dismals102010243dismals
dismays13237433dis_mays
disobey1346243disobey
dispart101115283dispart
dispel9310323disp_el
dispels10310503dispels
dispend11289413dispend
displaced1546793displaced
displacer1446433displacer
displaces1448593displaces
displants1248073displants
displayers1654823displayers
displaying1746313displaying
displease1245523displease
displode1247643displode
displume1344803displume
disport101015953disport
disposal1147023disposal
dispose10312763dispose
dispread1247103dispread
dispute1039083dispute
disseat83816923disseat
distal73615773dis_tal
distally1239553distally
downplay1742873downplay
endplay13103963endplay
fishway1943813fishway
gunplay1343233gunplay
hiply134113613hi_pl_y
imply124911843_impl_y
inlay85214323_i_nlay
jimply20397483jimpl_y
limply133810033limpl_y
misally121111063misally
mislays12349243mis_lays
misplace1437553misplace
misplans1238863misplans
misplant12410753misplant
misplayed1745303misplayed
misplead1345023misplead
mispled12310463mispled
missay114112143mis_say
nonplay1246683nonplay
outplay12267723outplay
pimply15329213pimpl_y
play95928983___play
redisplays1651593redisplays
replay113412923_replay
respray1236503respray
ripply13348003rippl_y
simply133010523simpl_y
slay76436383__s_lay
spay96631663__sp_ay
splat76129343__splat
splays114910873__splays
spray106720063__spray
virelay1335943virelay
wisely122711713wisel_y
wispily1535653wispily
wispy137210973wisp__y

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271066.48320673.6
3Display Results1061060.0303533.3
 (SQL Overall)1786911066.93625762.8
 
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.