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 “crappiest” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 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
crappiest1526727(None) 
crampiest15268621crampiest
crappies142911171crappies_
scrappiest1644161scrappiest
campiest142212142c_ampiest
chappies172610102chappies_
chippiest18256812chippiest
choppiest18226382choppiest
crabbiest1535622crabbiest
craftiest1436912craftiest
craggiest13116522craggiest
crankiest1538822crankiest
crappie13298992crappie__
crappier14288142crappie_r
crawliest14187402crawliest
craziest19319922cra_ziest
creepiest1337062creepiest
crepiest12310382cr_epiest
crimpiest15237182crimpiest
crispiest13197422crispiest
croppies143111152croppies_
croupiest1337062croupiest
cuppiest1448202c_uppiest
drippiest1445382drippiest
flappiest1644862flappiest
gappiest13259482_gappiest
grapiest112211932gra_piest
grippiest1435162grippiest
happiest152411682_happiest
nappiest122510892_nappiest
pappiest112611122_pappiest
preppiest1236982preppiest
raspiest10311282_raspiest
sappiest122612582_sappiest
snappiest1346502snappiest
strappiest1444382strappiest
trampiest13227902trampiest
trippiest1336602trippiest
zappiest21228032_zappiest
braggiest13116783braggiest
brainiest11209723brainiest
brakiest143912243bra_kiest
branniest11199383branniest
brashiest14359863brashiest
brassiest11369713brassiest
brattiest1148103brattiest
brawliest14177193brawliest
brawniest14197103brawniest
cagiest102916433c_a_giest
cakiest133215663c_a_kiest
canniest10313363c_anniest
cattiest103016333c_attiest
chaffiest2045423chaffiest
chalkiest1837093chalkiest
chanciest1638383chanciest
chappie16298663chappie__
chariest13315513cha_riest
charriest1438263charriest
chattiest1448213chattiest
chippies17309763chippies_
chirpiest16286483chirpiest
clammiest1535743clammiest
clankiest1536673clankiest
classiest11309553classiest
clayiest1337923cla_yiest
clumpiest1535353clumpiest
coaliest10316223coa_liest
crackliest1844883crackliest
crampier14288903crampie_r
crampit1338863crampi__t
crampits1436273crampits_
crankest1438143cra_nkest
crannies10313013crannies_
crapes104727693cra_p_es_
crapped143912633crapp_e_d
crapper133913193crapp_e_r
crappers144011023crapp_ers
crapping153911453crappi_ng
crapulent1344743crapulent
crassest103411523cra_ssest
crazies183413853cra_zies_
creakiest15238593creakiest
creamiest13248933creamiest
creasiest11229943creasiest
creepies1239613creepies_
cripples14298403cripples_
crispest12177373crisp_est
croakiest15167173croakiest
croppie13278803croppie__
cruddiest1334453cruddiest
crumbiest1536253crumbiest
crummiest1545563crummiest
crumpliest1644123crumpliest
crustiest112410053crustiest
dippiest132511143_dippiest
draffiest1644363draffiest
draftiest1335943draftiest
draggiest12126413draggiest
drawliest13166243drawliest
droopiest1235743droopiest
floppiest1654793floppiest
frappes14328383frapp_es_
frumpiest1634543frumpiest
gloppiest1444833gloppiest
grabbiest1435323grabbiest
grainiest10188993grainiest
grapples13348123grapples_
grassiest10309513grassiest
gripiest11289633gr_ipiest
grumpiest1435023grumpiest
hippiest152611623_hippiest
hoppiest152610733_hoppiest
lippiest122310623_lippiest
loppiest122410113_loppiest
nappies114613403_nappies_
nippiest12279983_nippiest
orangiest1038463orangiest
pappies103214833_pappies_
peppiest11278573_peppiest
preppies1149693preppies_
quippiest2243993quippiest
raciest92820013_ra_ciest
rainiest81214923_rainiest
rammiest12299933_rammiest
randiest93418773_randiest
rangiest93115983_rangiest
rapidest1138543_rapidest
rapist82520673_ra_pi_st
rappees113611453_rappees_
rattiest83516113_rattiest
rippliest1334783_rippliest
ropiest93317773_r_opiest
roupiest102610293_roupiest
scraggiest1444373scraggiest
scrapies124612493scra_pies_
scrappier1544443scrappie_r
scrappiness1752293scrappiness
scrapples1534803scrapples_
scrawliest1553823scrawliest
scrawniest1543493scrawniest
scrimpiest1643753scrimpiest
slippiest1346473slippiest
sloppiest1345983sloppiest
snippiest1345733snippiest
soapiest102412853soa_piest
soppiest122511943_soppiest
stroppiest1444583stroppiest
swampiest1635033swampiest
tippiest122310023_tippiest
trapnest10310923tra_pnest
trashiest123110643trashiest
unhappiest1742423unhappiest
vampiest15237653_vampiest
waspiest1338823_waspiest
whippiest19265123whippiest
wrathiest1536983wrathiest
zippiest21248103_zippiest

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.423422437.4
2DLD Change Limit1486411576.87621617.4
3Display Results1571570.0762065.8
 (SQL Overall)1786911577.37524229.3
 
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.