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

321 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
sportier10201005(None) 
sporter93616551sport_er
spottier10207311spottier
partier93520712_partier
porkier133712342_porkier
pornier93413132_pornier
porter84224412_port_er
portiere1038772_portiere
portlier1038372_portlier
pottier93516492_pottier
poutier93215322_poutier
purtier93214092_purtier
shirtier1137942shirtier
shorter103515502short_er
shortie10411342shortie_
shorties11414582shorties
snootier8278382snootier
snorter74412662snort_er
snottier8217382snottier
snoutier8206972snoutier
sootier73916612s_ootier
sorrier72313732s_orrier
sorter64425092s_ort_er
sortie63621992s_ortie_
sortied83314102s_ortied
sorties74126402s_orties
sparkier14298032sparkier
sparrier10329142sparrier
spirier93214072spir_ier
spongier1135742spongier
spookier14175492spookier
spoonier10167652spoonier
sported104015432sport_ed
sporters103714062sport_ers
sportiest111711022sportiest
sportif1238802sporti_f
sportily1337732sportily
sporting112415462sporting
sportive1348332sportive
spotter94514882spo_tter
spouter94213222spout_er
sprier84119062sp_r_ier
spurrier10297692spurrier
spurter94013002spurt_er
stormier1036102stormier
aborter939933abort_er
artier63419733__artier
assorter866673assort_er
blottier10336413blottier
chertier1387873chertier
chortler13336843chortler
corkier133114303_corkier
cornier93017093_cornier
cottier93814173_cottier
courtier1059333courtier
deporter1169393deport_er
dirtier83312093_dirtier
dorkier122810023_dorkier
dotier73917033_do_tier
dottier83910923_dottier
exporter1737363export_er
flirtier1144893flirtier
floatier1136983floatier
footier104115113_footier
forkier144311593_forkier
forties104323863_forties
frontier1147313frontier
frostier1148163frostier
ghostier1235383ghostier
gorier73719373_gor_ier
gorsier83811073_gorsier
goutier82612353_goutier
grottier9316673grottier
groutier9297173groutier
heartier1139093heartier
hootier104915353_hootier
hornier103012463_hornier
horsier103013243_horsier
importer12308913import_er
joltier14318493_joltier
knottier12203983knottier
loftier1037763_loftier
moorier93113073moor_ier
mortiser1078473_mortiser
norther1039733_norther
orbier839993__orbier
parrier93717653_parrier
partied103516553_partied
partiers103514243_partiers
parties93230863_parties
partner92811393_partner
partyer12337873_partyer
pastier94320383_pastier
peatier94017233_peatier
perkier133813123_perkier
perter84422283_pert_er
pestier94317403_pestier
pettier94213613_pettier
pitier84019823_p_itier
platier93716293_platier
plottier10327263plottier
pockier153911603_pockier
podgier11338723_podgier
poetiser1037313_poetiser
poetizer1936813_poetizer
pointier1038303_pointier
pokier124914633_po_kier
politer92417073_politer
porgies103017003_porgies
porker124917543_por_ker
porkies133416493_porkies
ported94223243_port_ed
porters93722703_port_ers
portico11310143_portico
portieres1138213_portieres
porting103021783_porting
portion9615493_portion
portioner1158683_portioner
poster84129173_post_er
postie84123963_postie_
posties93128813_posties
pother113818853_po_ther
potter83926983_po_tter
potties93723543_potties
potzer174411213_po_tzer
pouter83923983_pout_er
powter114116033_powt_er
poxier153812113_po_xier
prier75027763_p_r_ier
prosier93817483_prosier
pursier94012753_pursier
puttier93314503_puttier
quartier1737543quartier
reporter10411423report_er
rootier74915393_rootier
saltier74318633s_altier
sarkier113413313s_arkier
savorier1136643savor_ier
scantier10309983scantier
scarier94017873scar_ier
scarrier10298453scarrier
scattier10267583scattier
scooter93312873scoot_er
scorcher15196783scorcher
scorer84818263scor__er
scorifier1445413scorifier
scorner9259763scor_ner
scoter83815483sco_t_er
scottie937463scottie_
scotties1039753scotties
scouter93313323scout_er
scouther1356943scouther
scurfier13267053scurfier
scurvier13255883scurvier
shiftier1436343shiftier
shittier1137313shittier
shoalier1137073shoalier
shoddier1334213shoddier
shooter103013993shoot_er
shorted113614403short_ed
shorten103511413short_en
shortener1245773shortener
shortia1048193shorti_a
shortias1148093shortias
shorting122514803shorting
shortish1437423shortish
shouter103213083shout_er
showier1339103sho_wier
siltier73413863s_iltier
skirter11338483skirt_er
slatier74016813s_latier
sleetier837883sleetier
slittier837003slittier
slobbier1254633slobbier
sloppier1255703sloppier
sloshier1135283sloshier
slotter73314453slo_tter
sluttier836453sluttier
smarmier1235033smarmier
smarter94113133smart_er
smartie9310173smartie_
smarties10312873smarties
smirkier1444433smirkier
smoggier1243973smoggier
smokier1356703smo_kier
smoother13196673smoother
smother123510213smo_ther
smuttier1035213smuttier
snarkier12336513snarkier
snarlier8278183snarlier
snobbier1234633snobbier
snoopier10177273snoopier
snoozier17185193snoozier
snorer64316763snor__er
snorted83813493snort_ed
snorters83410583snort_ers
snorting92613373snorting
snowier1038793sno_wier
soapier93411713s_oapier
softer94015313s_oft_er
softie93312483s_oftie_
softies103414613s_ofties
soggier93410883s_oggier
soldier82812153s_oldier
sonsier7711743s_onsier
soother104215043s_oother
soppier112711583s_oppier
sorer56236593s_or__er
sorites73825243s_orites
sorner64720393s_or_ner
sorted74523713s_ort_ed
sorters74221133s_ort_ers
sorting83221813s_orting
soupier93111753s_oupier
souter64225923s_out_er
souther104116303s_outher
spacier114011633sp_acier
sparer84524963spar__er
sparger103613083spar_ger
sparker133914363spar_ker
sparkler14317983sparkler
sparklier1554363sparklier
sparser94311483spar_ser
spartina1037983spartina
spatter94016523sp_atter
specter113111733spect_er
speedier1146623speedier
spelter94113703spelt_er
spendier1147143spendier
spherier1337783spherier
spicier115112463sp_icier
spier75728033sp___ier
spiffier16255883spiffier
spikier13369983sp_ikier
spinier93715163sp_inier
spirited1148973spirited
spirted103913073spirt_ed
spirting112913633spirting
spitter94015183sp_itter
splatter10348883splatter
splitter10348443splitter
splurgier1252343splurgier
splutter10357443splutter
spoiler93310683spo_iler
sponger1038523spo_nger
spoofer12368723spo_ofer
spooler93711383spo_oler
spoonies101911753spoonies
spore75428593spor__e_
spored94821793spor__ed
spores84726613spor__es
sporing104319413spor_ing
sporoid102310733sporoi_d
sport75935983sport___
sportful1344513sportful
sportiness1278233sportiness
sportively1845023sportively
sports84619183sport__s
sportsmen1343543sportsmen
sportswear1551343sportswear
sporty115112493sport__y
sporular1065223sporular
sporule937273sporule_
sporules1037703sporules
spotted103713143spo_tted
spotters104313383spo_tters
spottiest11177683spottiest
spottily1335153spottily
spotting112812093spotting
spouted103412263spout_ed
spouters104011163spout_ers
spouting113511953spouting
sprayer12369043sp_rayer
sprite84421773sp_rite_
sprites94220333sp_rites
spritzer1944563spritzer
sprucer11317683sp_rucer
sprucier1254793sprucier
spryer11418533sp_r_yer
spumier1137903sp_umier
spunkier14235823spunkier
spurner9269653spur_ner
spurrer93710223spur_rer
spurriers11245063spurriers
spurries102311323spurries
spurted103111973spurt_ed
spurters103311703spurt_ers
spurting113111633spurting
spurtle937453spurtle_
spurtles1037783spurtles
sputter94014053sp_utter
starrier8279463starrier
starter73817883start_er
startler8248793startler
stockier14217253stockier
stodgier1034223stodgier
stonier72013793sto_nier
storer64721673stor__er
storied8515163stor_ied
stories7324273stor_ies
stouter74012053stout_er
sturdier9216963sturdier
sultrier837773sultrier
supporter1344513support_er
surfier102613543s_urfier
surlier72915443s_urlier
swarthier1543783swarthier
sweatier1147033sweatier
swirlier1135213swirlier
swoonier11185133swoonier
swoopier13175143swoopier
swotter10399473swo_tter
tartier74123263_tartier
thornier1135323thornier
troutier8277153troutier
wartier103413913_wartier
wordier112511213_wordier
wormier12278763_wormier
worrier102311683_worrier
worthier1436713_worthier
zootier163611173_zootier

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 Filter1786911461620.420425454.8
2DLD Change Limit1461623216.76621602.4
3Display Results3213210.1262547.6
 (SQL Overall)1786913217.31224438.0
 
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.