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

74 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
playday164382(None) 
payday1536611p_ayday
playdays1742971playdays
mayday1535872_mayday
paydays1634432p_aydays
playa105812942play_a_
playas114612282play_as
playboy1743812playboy
playdate1465262playdate
blandly1336043blandly
clayey14407663clay_ey
claypan1434313claypan
flyaway1943163flyaway
flyway18134693fl_yway
gaydar1135503_gaydar
gladly11497933gla_dly
glady105413943gla_d_y
heyday1635143_heyday
holyday1743773holyday
lady86527153_la_d_y
landau7310613_landau
lardy96119273_lard_y
layaway1643933_layaway
layman113511303_layman
maydays1634483_maydays
naysay1234973_naysay
paddy125913593p_a_ddy
paludal1035683paludal
panda85022613p_anda_
pandas95521963p_andas
pandy115021173p_and_y
pardah123412823p_ardah
pardy115523953p_ard_y
parlay113713993p_arlay
placidly1644153placidly
plagal948573pla_gal
plagiary1443643plagiary
plaguey13335943plaguey
plaguy12386413pla_guy
plaid85118303plaid__
plaided11409643plaided
plaids94312443plaid_s
plainly1236473plainly
planar84212713pla_nar
plantar9369993plantar
plashy14448873pla_shy
plasma103810913plasma_
plasmas113010753plasmas
platan83913693pla_tan
plateau937403plateau
platy105021663pla__ty
plaudit1046253plaudit
play95928983pl___ay
playact1446553playact
playback2144303playback
playboys1843653playboys
playdates1554903playdates
playdown1743593playdown
played124815033play_ed
player115215213play_er
players124313763players
playful1544653playful
playing133816093playing
playland1444573playland
playlet1239523playlet
playmate1566463playmate
playoff1843533playoff
playpen1434693playpen
plays106320773play__s
playwear1642103playwear
plaza164311063pla_za_
plazas17409913pla_zas
ploidy1237483ploid_y
waylay1535453_waylay

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 Filter1786911340270.1531167915.0
2DLD Change Limit134027747.42318055.6
3Display Results74740.0302466.7
 (SQL Overall)178691747.60623493.4
 
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.