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

78 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
playful154465(None) 
lapful1156482_lapful
lawful1235492_lawful
palmful1445052palmful
panful1179742p_anful
plateful1345432plateful
playfully2043212playfully
swayful1643002swayful
trayful1344582trayful
awful1178143__awful
bagful1237213_bagful
baleful1238003baleful
bellyful1642513bellyful
blameful1543813blameful
boatful1236283boatful
canful11610263_canful
capful1368173_capful
carful11610973_carful
earful958963_earful
fearful1345593fearful
glassful12113563glassful
gleeful1144323gleeful
hatful12108743_hatful
headful1445563headful
jarful1646683_jarful
joyful1943843_joyful
lapfuls1234503_lapfuls
layout9513703_layout
layup1037723_lay_up
manful11610213_manful
moanful12105003moanful
pageful1346353pageful
pailful1236103pailful
painful1246413painful
palmfuls1543473palmfuls
panfuls1237183p_anfuls
payout11714653p_ayout
peaceful1545463peaceful
pipeful1445643pipeful
pitiful1245863pitiful
plagal948573pla_gal
plague93610853pla_gue
plaguy12386413pla_guy
plaintful1442183plaintful
planula935773pla_nula
plaque17317643pla_que
platefuls1443963platefuls
platesful1442823platesful
platypus1542353platypus
play95928983play___
playa105812943play__a
playable15137923playable
playact1446553playact
playas114612283play_as
playbill1543373playbill
playboy1743813playboy
playday1643823playday
played124815033play_ed
player115215213play_er
players124313763players
playfield1841663playfield
playgirl1442553playgirl
playing133816093playing
playlet1239523playlet
playoff1843533playoff
playoffs1942793playoffs
playpen1434693playpen
plays106320773play__s
playsuit1343773playsuit
potful1138083p_otful
poutful1236743poutful
prayerful1752373prayerful
pushful1544493pushful
tearful1046033tearful
trayfuls1443483trayfuls
unlawful1441783unlawful
vatful12107083_vatful
waeful1238123_waeful

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.406440125.6
2DLD Change Limit134027786.59320328.7
3Display Results78780.0302600.0
 (SQL Overall)178691787.02925422.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.