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

299 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
scarrier1029845(None) 
carrier93619581_carrier
scarier94017871sca_rier
sparrier10329141sparrier
starrier8279461starrier
barrier94017732_barrier
carried103717152_carried
carriers103614202_carriers
carries94328012_carries
charrier1378682charrier
currier93316702_currier
farrier103514892_farrier
harrier104417752_harrier
marrier93817522_marrier
parrier93717652_parrier
quarrier1736842quarrier
sarkier113413312s_arkier
scabbier1435132scabbier
scalier94316912sca_lier
scantier10309982scantier
scarcer113911372sca_rcer
scareder1135792scareder
scarer84524612sca_r_er
scarfer124511082sca_rfer
scarifier1446652scarifier
scarper114814822sca_rper
scarred104512632scarr_ed
scarriest11188392scarriest
scarring112511512scarring
scattier10267582scattier
scurfier13267052scurfier
scurried11267052scurried
scurries102911482scurries
scurvier13255882scurvier
smarmier1235032smarmier
snarkier12336512snarkier
snarlier8278182snarlier
sorrier72313732s_orrier
sparkier14298032sparkier
spurrier10297692spurrier
tarrier74323172_tarrier
aerier64823153__aerier
airier64619363__airier
arriver10117793__arriver
artier63419733__artier
barkier133814483_barkier
barmier114313043_barmier
barnier93213673_barnier
barriers104311883_barriers
blurrier1035163blurrier
burrier93613553_burrier
cagier93715933_ca_gier
cahier113615773_ca_hier
cakier123115243_ca_kier
campier133313273_campier
cannier94014163_cannier
carder94524183_ca_rder
career85822243_ca_reer
carer74942333_ca_r_er
caried94528693_ca_ried
caries85147623_ca_ries
carnie84421093_carnie_
carnies94123963_carnies
caroler93816753_caroler
carper104923633_ca_rper
carrel84718633_carr_el
carrion9312673_carrion
carrotier1146623_carrotier
carter84932273_ca_rter
carver114420153_ca_rver
cashier123713323_cashier
catbrier1236173_catbrier
cattier93317073_cattier
charier124317903_charier
corkier133114303_corkier
cornier93017093_cornier
corrie83621223_corrie_
corries94026793_corries
courier93617893_courier
crazier183610743_crazier
crier74724463_c__rier
curdier103312623_curdier
curlier93314183_curlier
currie84317263_currie_
curried103313653_curried
curriers103410753_curriers
curriery13326163_curriery
curries93723163_curries
curvier123110663_curvier
earlier72612743_earlier
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
miscarried1543823miscarried
miscarries1445443miscarries
nearlier836793nearlier
noncarrier1254033noncarrier
parried103615723_parried
parriers103612903_parriers
parries93925843_parries
partier93520713_partier
pearlier1037323pearlier
quarried1836093quarried
quarriers1845183quarriers
quarries1749943quarries
quartier1737543quartier
recarried1244983recarried
recarries1147863recarries
saggier92912063s_aggier
sagier73717163s_a_gier
sallier73320423s_allier
saltier74318633s_altier
sandier84017843s_andier
sappier113613113s_appier
sassier73413233s_assier
saucier9810283s_aucier
sauries72821623s_auries
savorier1136643savorier
savvier1335483s_avvier
scabies11613333sca_bies
scaler84321603sca__ler
scalper113912923sca_lper
scammer133611973sca_mmer
scamper134613163sca_mper
scampies1439323scampies
scamster1235303scamster
scanner94411813sca_nner
scanter94215183sca_nter
scanties103215423scanties
scarce104013633sca_rce_
scarcity1545093scarcity
scare75334463sca_r_e_
scared95227293sca_r_ed
scarers94618513sca_r_ers
scares85033003sca_r_es
scarey115016983sca_r_ey
scarfed134711183sca_rfed
scarfers13408463sca_rfers
scarfing14309713scarfing
scariest101615943sca_riest
scarified1547293scarified
scarifiers1544103scarifiers
scarifies1439603scarifies
scarify1537443sca_rify
scarily12311703sca_rily
scaring103421973sca_ring
scarlet91516943sca_rlet
scarped124314403sca_rped
scarpers124712513sca_rpers
scarphed1635443scarphed
scarping133312463scarping
scarry116311183scarr__y
scarted104816123sca_rted
scarting113415263scarting
scarves124511623sca_rves
scatter93815173sca_tter
scauper11379453sca_uper
schizier2234063schizier
scorcher15196783scorcher
scorer84818263sc_or_er
scorifier1445413scorifier
scorner9259763sc_orner
scourer93910433scour_er
scourger1134723scourger
scraggier1344133scraggier
scraper114513423sc_raper
scrapie115010943scrapie_
scrapies124612473scrapies
scrapper1466973scrapper
scrappier1544423scrappier
scrawler1345893scrawler
scrawlier1443903scrawlier
scrawnier1443643scrawnier
screwer124410073sc_rewer
screwier1346433screwier
scriber113910973sc_riber
scried95817303sc__ried
scries85226823sc__ries
scummier1445083scummier
scurril945113scurri_l
scurrile1055073scurrile
scurvies13248123scurvies
scuzzier1842713scuzzier
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
sharpie1238393sharpie_
sharpies13411223sharpies
sherries111812893sherries
shirtier1137943shirtier
skankier11184883skankier
skerries12168673skerries
slaggier10126953slaggier
slangier9117933slangier
slatier74016813sla_tier
slurried9285943slurried
slurries82710413slurries
smarter94113133sma_rter
smartie9310173smartie_
smarties10312873smarties
smearier1036953smearier
smirkier1444433smirkier
snaggier10136303snaggier
snakier112810003sna_kier
snappier1266213snappier
snarer64620843sna_r_er
snarler73610633sna_rler
snazzier1642483snazzier
sneerier878103sneerier
soapier93411713soa_pier
soarer64522243soa_r_er
spacier114011633spa_cier
sparer84524963spa_r_er
sparger103613083spa_rger
sparker133914363spa_rker
sparkler14317983sparkler
sparklier1554363sparklier
sparred104512863sparr_ed
sparriest11198783sparriest
sparring113112223sparring
sparser94311483spa_rser
spherier1337783spherier
spirier93214073s_pirier
sportier102010053sportier
sprier84119063s__prier
spurrer93710223spurr_er
spurriers11245063spurriers
spurries102311323spurries
staggier10167513staggier
stagier83513443sta_gier
stalkier1257073stalkier
starchier1436643starchier
starer64027363sta_r_er
starker114114693sta_rker
starred85013453starr_ed
starriest9159763starriest
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 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 Filter1786911461620.420425454.8
2DLD Change Limit1461622998.03018202.0
3Display Results2992990.1102718.2
 (SQL Overall)1786912998.56020875.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.