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

263 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
smearier103695(None) 
smearer94110401smear_er
blearier1037332blearier
drearier9297922drearier
learier73415662_learier
mealier93015902_mealier
meatier93214612_meatier
merrier92612302_merrier
scarier94017872s_carier
seamier93114632s_eamier
searer65432022s_ear_er
shearer104414682shear_er
sleazier1735122sleazier
smarmier1235032sm_armier
smarter94113132sm_arter
smeared104510622smear_ed
smearers10308622smear_ers
smeariest1138112smeariest
smearing113511752smearing
smellier1036792smellier
sneakier1245142sneakier
sneerier878102sneerier
spearer93913662spear_er
steadier937312steadier
steamier1048302steamier
sugarier937392sugarier
swearer10349952swear_er
sweatier1147032sweatier
tearier73815612_tearier
wearier103613282_wearier
aerier64823153_ae_rier
ambaries123312383ambaries
amercer1146373ame_rcer
beadier103513913_beadier
beakier134012163_beakier
beamier113411943_beamier
bearer85323913_bear_er
beerier93613023_beerier
besmearer1343163besmear_er
charier124317903_charier
cheerier1348003cheerier
clearer93710823clear_er
creakier14328333creakier
creamier12319063creamier
creasier103210193creasier
dearer74822803_dear_er
dearie73319813_dearie_
dearies83526273_dearies
decrier102713553_decrier
dreamier11287293dreamier
drearies92313413drearies
earlier72612743__earlier
earner63617223__earner
easier64218463__easier
eerier64320023__eerier
emeries91620023eme_ries
fearer94820183_fear_er
fierier103511193fie_rier
freakier15246483freakier
glarier84112203_glarier
gleamier1144913gleamier
greasier9298083greasier
headier113212953_headier
hearer94323643_hear_er
heartier1139093_heartier
heavier13429423_heavier
hoarier104211743_hoarier
impairer1244863impairer
imparter12357543imparter
leadier83212723_leadier
leafier10329833_leafier
leakier114010993_leakier
learner7319383_learner
leavier10319993_leavier
leerier73111503_leerier
mariner93315993_m_ariner
marker124420393_m_arker
marlier92614773_m_arlier
marrer83716673_m_arrer
marrier93817523_marrier
matier84321523_m_atier
mazier175013063_m_azier
meager94515203_mea_ger
mealie82519813_mealie_
mealies92821933_mealies
meander1049973_meander
meaner84617843_mea_ner
meanie83718393_meanie_
meanies93620743_meanies
measlier1036013_measlier
mercer105214203_me_rcer
merer75126233_me_r_er
merger95016483_me_rger
meshier123410853_meshier
messier93412923_messier
metier83517693_me_tier
mirier83918363_m_irier
moorier93113073_moorier
nearer64618893_near_er
nearlier836793_nearlier
onerier7311613one_rier
peakier134411443_peakier
pearler9310373_pearler
pearlier1037323_pearlier
pearter9412743_pearter
peatier94017233_peatier
queasier1734473queasier
queazier2642833queazier
querier16310013que_rier
readier83117423_readier
rearer64928913_rear_er
remarker14178493remarker
safaried1236253safaried
sagier73717163s__agier
salaried9311023salaried
salaries8319573salaries
sarkier113413313s__arkier
savorier1136643savorier
scalier94316913s_calier
scarcer113911373s_carcer
scarer84524613s_car_er
scarfer124511083s_carfer
scarper114814823s_carper
scarrier10298453scarrier
sealer63928963s_ea_ler
seamer84223613s_ea_mer
searcher13209103s_earcher
seared75232843s_ear_ed
searing83330923s_earing
seater64534163s_ea_ter
sedgier9399053s_edgier
seedier83513633s_eedier
seemlier1035193seemlier
seepier92912013s_eepier
semainier1144753semainier
serer55935513s_e_r_er
serger73819743s_e_rger
series64540973s_e_ries
serried82513963s_erried
serries73925353s_erries
server94917713s_e_rver
sexier13310683s_e_xier
shadier113111153s_hadier
shakier143411153s_hakier
shalier103116423s_halier
sharer95025483s_har_er
sharker144313813s_harker
sharper124312703s_harper
sheared114516003shear_ed
shearers113911323shear_ers
shearing123915903shearing
sheather1458233sheather
sheenier11167423sheenier
sheerer103813843sheer_er
shellier1138393shellier
shelvier1464913shelvier
sherries111812893sherries
shoalier1137073shoalier
skerries12168673skerries
slatier74016813s_latier
sleekier1245573sleekier
sleepier1036783sleepier
sleetier837883sleetier
smacker153410583sm_acker
smaller93410333sm_aller
smarted105012613sm_arted
smarten9348863sm_arten
smartie9310173sm_artie_
smarties10312873sm_arties
smasher123911023sm_asher
smatter93613333sm_atter
smear74416393smea___r
smears84714433smear__s
smeary114110803smear__y
smeller94212783sme_ller
smelter93311913sme_lter
smerked14327283sme_rked
smirker13327423sm_irker
smirkier1444433smirkier
smoggier1243973smoggier
smokier1356703sm_okier
smudgier1233753smudgier
smuttier1035213smuttier
snakier112810003s_nakier
snarer64620843s_nar_er
snarkier12336513s_narkier
snarler73610633s_narler
snarlier8278183s_narlier
sneaker112910453snea_ker
sneerer73512313sneer_er
sneezier1774333sneezier
soapier93411713s_oapier
soarer64522243s_oar_er
sorrier72313733s_orrier
spacier114011633s_pacier
sparer84524963s_par_er
sparger103613083s_parger
sparker133914363s_parker
sparkier14298033s_parkier
sparrier10329143sparrier
sparser94311483s_parser
speaker133311213spea_ker
speared104314423spear_ed
spearers103711143spear_ers
spearing113216103spearing
spearmen1234853spearmen
speedier1146623speedier
spendier1147143spendier
spherier1337783spherier
spirier93214073s_pirier
sprier84119063s__prier
spurrier10297693spurrier
squarer163410663squar_er
squeakier2242903squeakier
stagier83513443s_tagier
starer64027363s_tar_er
starker114114693s_tarker
starrier8279463starrier
starter73817883s_tarter
starver104611993s_tarver
steadied1036563steadied
steadiers1035083steadiers
steadies9311123steadies
stealer72913973stea_ler
steamer93313093stea_mer
stearic939423steari_c
stearin7312003steari_n
stearine8311903stearine
stearines9311283stearines
stearins8312143stearins
steelier839183steelier
steerer73113633steer_er
stemmier1245253stemmier
sterner7411913ste_rner
strawier1137493strawier
streakier1334843streakier
streamier1155763streamier
sudaries9312753sudaries
sugarer837323sugar_er
sultrier837773sultrier
summaries13118183summaries
summarizer23104273summarizer
summerier1346423summerier
swarmer1247803s_warmer
swearers11328583swear_ers
swearing123711443swearing
sweater103712723swea_ter
sweepier1355493sweepier
sweltrier1242993sweltrier
swerver1365733swe_rver
tearer64822903_tear_er
terrier73414963_terrier
tweakier1533143tweakier
uneasier836963uneasier
unwarier1136883unwarier
varier94619353__varier
vealier102712173_vealier
verier94620963_ve_rier
warier93722893__warier
wearer94319403_wear_er
wearied112911803_wearied
wearies103020223_wearies
yearner10336873_yearner

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.423422437.4
2DLD Change Limit1461622636.64022012.3
3Display Results2632630.1102390.9
 (SQL Overall)1786912637.17324911.6
 
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.