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

67 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
preppiness134442(None) 
peppiness1235181p_eppiness
creepiness1444882creepiness
preppies1149672preppi_e_s
preppiest1236972preppi_est
preppinesses1544872preppinesses
prettiness1257392prettiness
breeziness2143513breeziness
choppiness1973563choppiness
creakiness1645963creakiness
creaminess1446203creaminess
crispiness1444793crispiness
dippiness1435973_dippiness
dreaminess1345303dreaminess
dreariness1146283dreariness
dressiness1145543dressiness
floppiness1742863floppiness
freakiness1745183freakiness
grapiness1238243gr_apiness
greasiness1156533greasiness
greediness1245833greediness
grumpiness1543263grumpiness
happiness1635993_happiness
hippiness1635463_hippiness
lippiness1335413_lippiness
nappiness1335233_nappiness
nippiness1334713_nippiness
paperiness1446133paperiness
pepperiness1443433p_epperiness
peppiest11278563p_eppi_est
peppinesses1435313p_eppinesses
pepsines1239883p_epsine_s
perkiness15209163p_erkiness
peskiness15216523p_eskiness
pettiness1178703p_ettiness
pipiness1238003p__ipiness
preachiness1844283preachiness
prepossess1443073prepossess
preppie1058093preppi_e__
preppier1156643preppi_e_r
prepping12309763preppin__g
prepress12137973pre_p_ress
preprices1569263preprice_s
preprints1347473preprin_ts
preprocess1644053preprocess
prerinses1138813pre_rinses
prissiness1266133prissiness
promptness1643293promptness
properness1445923properness
propines122618933pr_opine_s
prosiness11311673pr_osiness
pulpiness1335603p_ulpiness
raspiness1137303_raspiness
readiness102611853_readiness
reediness10239613_reediness
repiners103913433_re_piners
repines94927383_re_pine_s
ropiness102311073_r_opiness
sappiness1337433_sappiness
scrappiness1752283scrappiness
sleepiness1245133sleepiness
sloppiness1443743sloppiness
snappiness1443823snappiness
soppiness1336543_soppiness
trendiness1146223trendiness
trephines1448483trephine_s
weepiness14215963_weepiness

Search took 10 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 Filter1786911406030.1561145455.1
2DLD Change Limit140603678.21617113.3
3Display Results67670.0501340.0
 (SQL Overall)178691678.42221217.2
 
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.