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

203 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
sportiest11171102(None) 
spottiest11177681spottiest
porkiest143513712_porkiest
porniest103214312_porniest
portliest11310182_portliest
pottiest102815972_pottiest
poutiest103016792_poutiest
purtiest102414112_purtiest
shirtiest1239322shirtiest
shortest11310782short_est
shorties11414582shorties_
snootiest9178752snootiest
snottiest9167972snottiest
snoutiest9178252snoutiest
sootiest84016752s_ootiest
sorriest8413882s_orriest
sorties74126402s_orties_
sparkiest15188092sparkiest
sparriest11198782sparriest
spiriest102513452spir_iest
spongiest1237082spongiest
spookiest15156392spookiest
spooniest11178132spooniest
sportier102010052sportie_r
sportiness1278232sportiness
spriest92718642sp_r_iest
stormiest1137002stormiest
artiest73121993__artiest
blottiest11286833blottiest
chertiest1438793chertiest
corkiest143114793_corkiest
corniest102117303_corniest
dirtiest93014203_dirtiest
dorkiest133111253_dorkiest
dotiest83717453_do_tiest
dottiest92611393_dottiest
flirtiest1236193flirtiest
floatiest1237283floatiest
footiest113514913_footiest
forkiest153812303_forkiest
forties104323863_forties_
frostiest1239213frostiest
ghostiest1336543ghostiest
goriest82218743_gor_iest
gorsiest92511133_gorsiest
goutiest93013883_goutiest
grottiest10147183grottiest
groutiest10147763groutiest
heartiest12311103heartiest
hootiest113115643_hootiest
horniest112814043_horniest
horsiest112513263_horsiest
joltiest15249403_joltiest
knottiest13174563knottiest
loftiest1139083_loftiest
mooriest102812723moor_iest
orbiest9312413__orbiest
parties93230863_parties_
pastiest103319543_pastiest
peatiest103118803_peatiest
perkiest143313243_perkiest
pertest9317043_pert_est
pestiest103018413_pestiest
pettiest103113963_pettiest
platiest103216083_platiest
plottiest11287833plottiest
pockiest163412053_pockiest
podgiest12269093_podgiest
pointiest1139623_pointiest
pokiest133314913_po_kiest
politest10312943_politest
porgies103017003_porgies_
porkies133416493_porkies_
portent93619643_port_ent
portiere1038773_portiere
portless10310643_portless
portress1038323_portress
posties93128813_posties_
posttest10410233_posttest
potties93723543_potties_
poxiest163412253_po_xiest
priest84125423_p_r_iest
prosiest10416523_prosiest
protest9317533_prot_est
protist9320223_proti_st
pursiest102812123_pursiest
rootiest83115593_rootiest
saltiest83117713s_altiest
sarkiest123615063s_arkiest
savoriest1246613savor_iest
scantiest112611003scantiest
scariest101615943scar_iest
scarriest11188393scarriest
scattiest11268363scattiest
scotties1039753scotties_
scurfiest14236863scurfiest
scurviest14266123scurviest
shiftiest1537363shiftiest
shittiest1238333shittiest
shoaliest1238503shoaliest
shoddiest1434753shoddiest
shortias1148093shortias_
shortie10411343shortie__
shortish1437423shorti_sh
shortlist1246683shortlist
shortness1236733shortness
showiest1438783sho_wiest
siltiest83515613s_iltiest
slatiest82616263s_latiest
sleetiest938553sleetiest
slittiest938203slittiest
slobbiest1345083slobbiest
sloppiest1345973sloppiest
sloshiest1246673sloshiest
sluttiest937333sluttiest
smarmiest1335903smarmiest
smartest10310183smart_est
smarties10312873smarties_
smirkiest1535193smirkiest
smoggiest1334463smoggiest
smokiest1437883smo_kiest
smoothest14215773smoothest
smuttiest1135973smuttiest
snarkiest13207633snarkiest
snarliest91810203snarliest
snobbiest1354963snobbiest
snoopiest11157063snoopiest
snooziest18175393snooziest
snowiest1138143sno_wiest
soapiest102412843s_oapiest
softest10310603s_oft_est
softies103414613s_ofties_
soggiest102711643s_oggiest
sonsiest8313033s_onsiest
soothest113312243s_oothest
soppiest122511933s_oppiest
sorest65028003s_or__est
sorites73825243s_orites_
sortie63621993s_ortie__
sortied83314103s_ortie_d
soupiest102212913s_oupiest
spaciest122310893sp_aciest
sparest94616423spar__est
sparkliest1644573sparkliest
sparsest1048813spar_sest
speediest1257463speediest
spendiest1237523spendiest
spheriest1438373spheriest
spiciest122711603sp_iciest
spiffiest17235653spiffiest
spikiest14259533sp_ikiest
spiniest102813223sp_iniest
spiritist1148093spiritist
splurgiest1343213splurgiest
spoonies101911753spoonies_
spores84726613spor__es_
sporocyst1643473sporocyst
sported104015433sport_e_d
sporter93616553sport_e_r
sporters103714063sport_ers
sportif1238803sporti__f
sportily1337733sporti_ly
sporting112415463sporti_ng
sportive1348333sporti_ve
sportively1845023sportively
sports84619183sport__s_
sportscast1452593sportscast
sporules1037703sporules_
spotless1037043spo_tless
spottier10207313spottie_r
spottiness1285763spottiness
spoutless1134243spoutless
sprites94220333sp_rites_
sprucest12295783sp_rucest
spruciest1345143spruciest
spryest12247813sp_r_yest
spumiest1238203sp_umiest
spunkiest15166563spunkiest
spurries102311323spurries_
spurtles1037783spurtles_
starriest9159763starriest
stockiest15207753stockiest
stodgiest1135653stodgiest
stoniest8413543sto_niest
stories7324273stor_ies_
stoutest837613stout_est
sturdiest10207393sturdiest
sultriest938653sultriest
surfiest112414433s_urfiest
surliest82416913s_urliest
swarthiest1644743swarthiest
sweatiest1238413sweatiest
swirliest1236293swirliest
swooniest12176293swooniest
swoopiest14155383swoopiest
tartiest82718313_tartiest
thorniest1236483thorniest
troutiest9127803troutiest
wartiest113614643_wartiest
wordiest122311543_wordiest
wormiest13249543_wormiest
worthiest1538323_worthiest
zootiest173311213_zootiest

Search took 9 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.500357382.0
2DLD Change Limit1486412037.51619776.6
3Display Results2032030.0932182.8
 (SQL Overall)1786912038.10922036.1
 
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.