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

264 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
snarlier827818(None) 
gnarlier9255161gnarlier
snarkier12336511snarkier
snarler73610631snarl_er
earlier72612742_earlier
knurlier1242882knurlier
marlier92614772_marlier
nearlier836792nearlier
pearlier1037322pearlier
sallier73320422s_allier
sarkier113413312s_arkier
scalier94316912sca_lier
scarier94017872scar_ier
scarrier10298452scarrier
shalier103116422sha_lier
smarmier1235032smarmier
snaggier10136302snaggier
snakier112810002sna_kier
snappier1266212snappier
snarer64620842snar__er
snarled83612362snarl_ed
snarlers8298752snarl_ers
snarliest91810202snarliest
snarling92513182snarling
snazzier1642482snazzier
sparkier14298032sparkier
sparklier1554362sparklier
sparrier10329142sparrier
starrier8279462starrier
surlier72915442s_urlier
swirlier1135212swirlier
angrier839023angr_ier
artier63419733__artier
barkier133814483_barkier
barmier114313043_barmier
barnier93213673_barnier
barrier94017733_barrier
brawlier13267043brawlier
burlier93514413_burlier
carrier93619583_carrier
charier124317903char_ier
charlie123011923charlie_
charlies133414233charlies
charrier1378683charrier
coalier93416183coa_lier
crawlier13216873crawlier
curlier93314183_curlier
dallier84215373_dallier
danglier1056753danglier
darklier1335013_darklier
deadlier1036863deadlier
drawlier12225253drawlier
enabler9299363enabl_er
espalier1036363espa_lier
farrier103514893_farrier
featlier1136453featlier
ganglier1047603ganglier
girlier8289523_girlier
gladlier1034343gladlier
glarier84112203glar_ier
gnarled9287723gnarl_ed
gnarliest10186553gnarliest
gnarling10217603gnarling
gnattier934263gnattier
hardier114721543_hardier
harrier104417753_harrier
haulier1059943_haulier
heartier1139093heartier
hoarier104211743hoar_ier
inlier63615363in__lier
janglier1656113janglier
lardier83518343_lardier
larkier113711523_larkier
learier73415663lear_ier
manlier92414023_manlier
marblier1256343_marblier
marrier93817523_marrier
mealier93015903mea_lier
measlier1036013measlier
naggier9309153_naggier
nailer64119363_nail_er
nappier114411173_nappier
nastier74115293_nastier
nattier73614623_nattier
nerdier83110353_nerdier
nervier10298833_nervier
onerier7311613oner_ier
palier85023563_pa_lier
pallier94417163_pallier
parrier93717653_parrier
partier93520713_partier
pearler9310373pearl_er
quarrier1736843quarrier
quartier1737543quartier
rallier73816273_rallier
saggier92912063s_aggier
sagier73717163s_a_gier
sailer63526103s_ail_er
sallied83316953s_allied
salliers83613343s_alliers
sallies73227813s_allies
salter64325083s_a_lter
saltier74318633s_altier
salver94617753s_a_lver
sandier84017843s_andier
sappier113613113s_appier
sassier73413233s_assier
saucier9810283s_aucier
savvier1335483s_avvier
scabbier1435133scabbier
scaler84321603sca_l_er
scalper113912923sca_lper
scantier10309983scantier
scarcer113911373scar_cer
scareder1135783scareder
scarer84524603scar__er
scarfer124511083scar_fer
scarifier1446653scarifier
scarlet91516943scarl_et
scarper114814823scar_per
scattier10267583scattier
scrawlier1443893scrawlier
scurfier13267053scurfier
scurvier13255883scurvier
sealer63928963sea_l_er
seamier93114633sea_mier
searcher13209103searcher
searer65432023sear__er
seemlier1035193seemlier
shabbier1535183shabbier
shadier113111153sha_dier
shaggier13116053shaggier
shakier143411153sha_kier
shapelier1444463shapelier
sharer95025483shar__er
sharker144313813shar_ker
sharper124312703shar_per
sharpie1238393sharpie_
sharpies13411223sharpies
shellier1138393shellier
shirtier1137943shirtier
shoalier1137073shoalier
sicklier1457213sicklier
sillier74017593s_illier
skankier11184883skankier
slaggier10126953slaggier
slangier9117933slangier
slatier74016813sla_tier
slier54827243s___lier
smaller93410333sma_ller
smarter94113133smar_ter
smartie9310173smartie_
smarties10312873smarties
smearier1036953smear_ier
smellier1036793smellier
smirkier1444433smirkier
snacker133112603sna_cker
snaglike1335283snaglike
snailed83811923snail_ed
snailing92912973snailing
snapper113512073sna_pper
snare54429983snar__e_
snared74824553snar__ed
snarers74216663snar__ers
snares65329033snar__es
snarfed11378753snar_fed
snarfing12358663snarfing
snaring83920953snar_ing
snarkiest13207633snarkiest
snarkily1534583snarkily
snarl54921083snarl___
snarls64016873snarl__s
snarly93815003snarl__y
snatcher13167763snatcher
snatchier1455353snatchier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
sneller73512843sn_eller
sniffier14356643sniffier
snippier1255793snippier
snobbier1234633snobbier
snoopier10177273snoopier
snootier8278383snootier
snoozier17185193snoozier
snorer64316763snor__er
snorter74412663snor_ter
snottier8217383snottier
snoutier8206973snoutier
snowier1038793sn_owier
snubbier1244993snubbier
snuffier14276943snuffier
snufflier1543303snufflier
soapier93411713soa_pier
soarer64522243soar__er
sorrier72313733s_orrier
spacier114011633spa_cier
spaller92713473spa_ller
spanglier1244193spanglier
sparer84524963spar__er
sparger103613083spar_ger
sparker133914363spar_ker
sparkler14317983sparkler
sparlike1437673sparlike
sparling112714533sparling
sparser94311483spar_ser
spirier93214073spir_ier
sportier102010053sportier
sprawlier1443293sprawlier
sprier84119063s_pr_ier
spurrier10297693spurrier
squallier1844363squallier
stabler94014933stabl_er
staggier10167513staggier
stagier83513443sta_gier
staler64025823sta_l_er
stalker113912253sta_lker
stalkier1257073stalkier
stapler93913633stapl_er
starchier1436643starchier
starer64027363star__er
starker114114693star_ker
starlet71620123starl_et
starlike1238813starlike
starling93017123starling
starlit71512913starli_t
starter73817883star_ter
startler8248793startler
starver104611993star_ver
statelier945653statelier
steelier839183steelier
stillier868823stillier
stormier1036103stormier
strawier1137483strawier
studlier935473studlier
sturdier9216963sturdier
sugarier937393sugar_ier
supplier1246603supplier
surfier102613543s_urfier
swampier1544593swampier
swankier15225503swankier
swarmer1247803swar_mer
swarthier1543783swarthier
tallier72817213_tallier
tanglier948073tanglier
tardier859719993_tardier
tarrier74323173_tarrier
tarsier74119253_tarsier
tartier74123263_tartier
tearier73815613tear_ier
twirlier1133513twirlier
unallied938393unallied
unholier1137283unholier
unmanlier1144243unmanlier
unrulier845333unrulier
unwarier1136883unwar_ier
varier94619353_var_ier
vealier102712173vea_lier
warier93722893_war_ier
wartier103413913_wartier
weaklier1534263weaklier
wearier103613283wear_ier
whirlier14175293whirlier
yearlies1137603yearlies

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.1561145455.1
2DLD Change Limit1461622646.86021306.4
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.12625075.9
 
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.