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

306 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
sparrier1032914(None) 
parrier93717651_parrier
scarrier10298451scarrier
sparkier14298031sparkier
spurrier10297691spurrier
starrier8279461starrier
barrier94017732_barrier
carrier93619582_carrier
charrier1378682charrier
farrier103514892_farrier
harrier104417752_harrier
marrier93817522_marrier
parried103615722_parried
parriers103612902_parriers
parries93925842_parries
partier93520712_partier
quarrier1736842quarrier
sarkier113413312s_arkier
scarier94017872sca_rier
smarmier1235032smarmier
snarkier12336512snarkier
snarlier8278182snarlier
sorrier72313732s_orrier
spacier114011632spa_cier
sparer84524962spa_r_er
sparger103613082spa_rger
sparker133914362spa_rker
sparkler14317982sparkler
sparklier1554362sparklier
sparred104512862sparr_ed
sparriest11198792sparriest
sparring113112222sparring
sparser94311482spa_rser
spherier1337782spherier
spirier93214072sp_irier
sportier102010052sportier
sprier84119062sp__rier
spurrer93710222spurr_er
spurriers11245062spurriers
spurries102311322spurries
tarrier74323172_tarrier
aerier64823153__aerier
airier64619363__airier
arriver10117793__arriver
artier63419733__artier
barkier133814483_barkier
barmier114313043_barmier
barnier93213673_barnier
barriers104311883_barriers
blurrier1035163blurrier
burrier93613553_burrier
carried103717153_carried
carriers103614203_carriers
carries94328013_carries
charier124317903cha_rier
currier93316703_currier
earlier72612743_earlier
espalier1036363espa_lier
farriers113610743_farriers
farriery14295403_farriery
firrier103410133_firrier
furrier103513663_furrier
gharries12318203gharries
glairier944833glairier
glarier84112203gla_rier
gnarlier9255163gnarlier
hairier103111053_hairier
hardier114721543_hardier
harried113815533_harried
harriers113712433_harriers
harries103525493_harries
heartier1139093heartier
hoarier104211743hoa_rier
hurrier103412943_hurrier
lardier83518343_lardier
larkier113711523_larkier
learier73415663lea_rier
marlier92614773_marlier
marrer83716673_marr_er
married104715303_married
marriers103312473_marriers
marries93825283_marries
merrier92612303_merrier
nearlier836793nearlier
pacier105018683_pa_cier
palier85023563_pa_lier
pallier94417163_pallier
palmier113312173_palmier
paltrier1037523_paltrier
panier84425503_pa_nier
pannier93613353_pannier
pappier103511603_pappier
parader103914863_parader
pardie96021443_pardie_
pardner10239473_pardner
parer75839903_pa_r_er
paries84742513_pa_ries
parker124121373_pa_rker
parred95024073_parr_ed
parrel84515983_parr_el
parring103222063_parring
parroter1058203_parroter
parser84822373_pa_rser
partied103516553_partied
partiers103514243_partiers
parties93230863_parties
partner92811393_partner
partyer12337873_partyer
pastier94320383_pastier
pawkier16236613_pawkier
pearlier1037323pearlier
perkier133813123_perkier
perries93226603_perries
porkier133712343_porkier
pornier93413133_pornier
prier75027763_p__rier
pursier94012753_pursier
purtier93214093_purtier
quarried1836093quarried
quarriers1845183quarriers
quarries1749943quarries
quartier1737543quartier
saggier92912063s_aggier
sagier73717163s_a_gier
sallier73320423s_allier
saltier74318633s_altier
sandier84017843s_andier
sappier113613123s_appier
sassier73413233s_assier
saucier9810283s_aucier
sauries72821623s_auries
savorier1136643savorier
savvier1335483s_avvier
scabbier1435133scabbier
scalier94316913sca_lier
scantier10309983scantier
scarcer113911373sca_rcer
scareder1135793scareder
scarer84524613sca_r_er
scarfer124511083sca_rfer
scarifier1446653scarifier
scarper114814823sca_rper
scarred104512633scarr_ed
scarriest11188403scarriest
scarring112511513scarring
scattier10267583scattier
scurfier13267053scurfier
scurried11267053scurried
scurries102911483scurries
scurvier13255883scurvier
seamier93114633sea_mier
searcher13209103searcher
searer65432023sea_r_er
serried82513963s_erried
serries73925353s_erries
shabbier1535183shabbier
shadier113111153sha_dier
shaggier13116053shaggier
shakier143411153sha_kier
shalier103116423sha_lier
sharer95025483sha_r_er
sharker144313813sha_rker
sharper124312703sha_rper
sharpie1238403sharpie_
sharpies13411233sharpies
sherries111812893sherries
shirtier1137943shirtier
skankier11184883skankier
skerries12168673skerries
slaggier10126953slaggier
slangier9117933slangier
slatier74016813sla_tier
slurried9285943slurried
slurries82710413slurries
smarter94113133sma_rter
smartie9310173smartie_
smarties10312873smarties
smearier1036953smearier
smirkier1444433smirkier
snaggier10136303snaggier
snakier112810003sna_kier
snappier1266223snappier
snarer64620843sna_r_er
snarler73610633sna_rler
snazzier1642483snazzier
sneerier878103sneerier
soapier93411713soa_pier
soarer64522243soa_r_er
spacer104917793spa__cer
spader94317133spa__der
spaller92713473spa_ller
spammer133410433spa_mmer
spanglier1244193spanglier
spaniel948923spa_niel
spanker133612353spa_nker
spanner94312563spa_nner
spare75135563spa_r_e_
spared95427493spa_r_ed
sparerib1264363spareri_b
spareribs1353283spareribs
sparers94519613spa_r_ers
spares84834553spa_r_es
sparge94216053spa_rge_
sparged113512763spa_rged
spargers11389733spa_rgers
sparges104016343spa_rges
sparging122611133sparging
sparid94016933spa_ri_d
sparids103512123spa_rids
sparing104823873spa_ring
sparked143513143spa_rked
sparkers144111313spa_rkers
sparkiest15188103sparkiest
sparkily1735023sparkily
sparking152812543sparking
sparkish17276973sparkish
sparkle133710213sparkle_
sparkled15317733sparkled
sparklers15315643sparklers
sparkles143210493sparkles
sparklet143110593sparklet
sparlike1437673sparlike
sparling112714533sparling
sparoid102311543sparoi_d
sparoids11218713sparoids
sparrow1234263sparr_ow
sparrows1344803sparrows
sparry115111303sparr__y
sparse84516343spa_rse_
sparsity1345463sparsity
spartina1037983spartina
spatter94016523spa_tter
spavie113611383spa_vie_
spavies123012953spa_vies
spaviet123011933spa_viet
spawner12347363spa_wner
spearer93913663spear_er
speedier1146623speedier
spendier1147143spendier
spicier115112463sp_icier
spiderier1244653spiderier
spier75728033sp___ier
spiffier16255883spiffier
spikier13369983sp_ikier
spinier93715163sp_inier
splashier1443593splashier
splurger1143813splurger
splurgier1252343splurgier
spongier1135743spongier
spookier14175493spookier
spoonier10167653spoonier
sporter93616553sp_orter
spottier10207313spottier
sprawler1334653sprawler
sprawlier1443293sprawlier
sprayer12369043sp_rayer
sprucer11317683sp_rucer
sprucier1254793sprucier
spryer11418533sp__ryer
spumier1137903sp_umier
spunkier14235823spunkier
spurner9269653sp_urner
spurred103610623spurr_ed
spurrers10338463spurr_ers
spurrey12307813spurr_ey
spurring11339763spurring
spurter94013003sp_urter
staggier10167513staggier
stagier83513443sta_gier
stalkier1257073stalkier
starchier1436643starchier
starer64027363sta_r_er
starker114114693sta_rker
starred85013453starr_ed
starriest9159773starriest
starring92312953starring
starter73817883sta_rter
startler8248793startler
starver104611993sta_rver
stirrer7338233stirr_er
stormier1036103stormier
strawier1137493strawier
sturdier9216963sturdier
sugarier937393sugarier
sultrier837773sultrier
surfier102613543s_urfier
surlier72915443s_urlier
swampier1544593swampier
swankier15225503swankier
swarmer1247803swa_rmer
swarthier1543783swarthier
swirlier1135213swirlier
tardier859719993_tardier
tarried83914133_tarried
tarriers83411713_tarriers
tarries73324263_tarries
tarsier74119253_tarsier
tartier74123263_tartier
tearier73815613tea_rier
terrier73414963_terrier
varier94619353_va_rier
warier93722893_wa_rier
warrior1045363_warrior
wartier103413913_wartier
wearier103613283wea_rier
worrier102311683_worrier

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 Limit1461623066.47022590.7
3Display Results3063060.1262428.6
 (SQL Overall)1786913067.01625469.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.