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

80 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
spruciest134514(None) 
sprucest12295781spruc_est
priciest122112902_priciest
sauciest10310972s_auciest
sirupiest1154752sirupiest
spaciest122310892sp_aciest
spiciest122711602sp_iciest
spriest92718642spr__iest
spruces113810502spruc_es_
sprucier1254792sprucie_r
spumiest1238202sp_umiest
syrupiest1453222syrupiest
paciest112917803_p_aciest
pluckiest1735293_pluckiest
plumiest122110293_plumiest
pouchiest1636843_pouchiest
poutiest103016793_poutiest
precisest13259003_precisest
prickiest1748183_prickiest
priest84125423_pr__iest
priviest132310313_priviest
prosiest10416523_prosiest
prurient1048233_prurient
puniest92918093_p_uniest
pursiest102812123_pursiest
purtiest102414113_purtiest
raciest92820013__raciest
rubiest92914423__rubiest
ruliest72816433__ruliest
sarkiest123615063sar_kiest
screwiest1445473screwiest
scrubbiest1643163scrubbiest
scruffiest1842933scruffiest
scurfiest14236863scurfiest
scurviest14266123scurviest
shrubbiest1742353shrubbiest
slouchiest1543973slouchiest
snoutiest9178253snoutiest
sorriest8413883sor_riest
soupiest102212913s_oupiest
sparkiest15188093sparkiest
sparkliest1644573sparkliest
sparriest11198783sparriest
species11314133sp_ecies_
speediest1257463speediest
spendiest1237523spendiest
spheriest1438373spheriest
spiffiest17235653spiffiest
spikiest14259533sp_ikiest
spiniest102813223sp_iniest
spiriest102513453sp_iriest
splurgiest1343213splurgiest
spongiest1237083spongiest
spookiest15156393spookiest
spooniest11178133spooniest
sportiest111711023sportiest
spottiest11177683spottiest
sprawliest1543573sprawliest
spriggiest14174533spriggiest
springiest13156673springiest
sprocket1646773sprocke_t
sprockets1743253sprockets
spruce103910873spruc_e__
spruced12307533spruc_e_d
sprucely1543123spruc_ely
spruceness1444103spruceness
sprucer11317683spruc_e_r
sprucing1336893spruci_ng
sprues84515763spru__es_
spryest12247813spr__yest
spunkiest15166563spunkiest
spurries102311323spurries_
strawiest1237213strawiest
strictest1147293strictest
stripiest1138013stripiest
sturdiest10207393sturdiest
suckiest143314113s__uckiest
surfiest112414433sur_fiest
surliest82416913sur_liest
unruliest945873unruliest

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 Filter1786911486410.406440125.6
2DLD Change Limit148641806.95321378.0
3Display Results80800.0332424.2
 (SQL Overall)178691807.39224173.6
 
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.