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

90 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
pipeful144564(None) 
pipefuls1543751pipefuls
direful1156612direful
hopeful1545902hopeful
ireful948712_ireful
lifeful1344612lifeful
pageful1346352pageful
pitiful1245862pitiful
prideful1443912prideful
spiteful1344302spiteful
aidful1057073ai_dful
aimful1166703ai_mful
baleful1238003baleful
baneful1237893baneful
bipedal1245683bipedal
cageful1356483cageful
capful1368173cap_ful
careful1249113careful
cupful1356423cup_ful
cupsful1453433cupsful
dareful1157053dareful
dipperful1752133dipperful
dirgeful1343253dirgeful
dishful1455433dishful
doleful1146333doleful
easeful1037293easeful
eyeful1235903_eyeful
fateful1397513fateful
fistful1365903fistful
fitful1256333fi_tful
gleeful1144323gleeful
guileful1243313guileful
hateful13107683hateful
hopefuls1644063hopefuls
kistful1465303kistful
lapful1156483lap_ful
mindful1344613mindful
museful1245883museful
pagefuls1474343pagefuls
pailful1236103pailful
pailsful1343263pailsful
painful1246403painful
palmful1445053palmful
panful1179743p_anful
peaceful1545463peaceful
peepul1035783p_eepul
piceous11310693piceous
picul95015363pi__cul
pileous9510523pileous
pileum10399513pile_um
pileup10437923pile_up
pileus84514943pile_us
pineal84817683pine_al
pinetum1145553pinetum
pipal95118353pip__al
pipe86434433pipe___
pipeage1236203pipeage
piped105123163pipe__d
pipefish1844533pipefish
piper96523193pipe__r
pipers104318663pipe_rs
pipes96030143pipe__s
pipet95533323pipe__t
pipets105714773pipe_ts
pipette1137943pipette
piteous9310683piteous
pixel143911903pixe__l
plateful1345433plateful
playful1544653playful
potful1138083p_otful
poutful1236743poutful
powerful1653243powerful
pushful1544493pushful
rueful948203_rueful
sinful938803si_nful
spadeful1443963spadeful
tinful938043ti_nful
topful1136543top_ful
tuneful1046123tuneful
useful947013_useful
voiceful1643053voiceful
waeful1238123_waeful
wakeful1735613wakeful
wameful1535673wameful
wilful1235963wi_lful
willful1344533willful
wipeout1287873wipeout
wishful1664503wishful
wistful1365713wistful
woeful1236363_woeful

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.406440125.6
2DLD Change Limit134027905.93622578.7
3Display Results90900.0303000.0
 (SQL Overall)178691906.37228043.2
 
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.