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

206 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
safrols103686(None) 
safrol937281safrol_
safrole1037251safrole
safroles1136931safroles
carols85124982ca_rols
parols84722612pa_rols
patrols93513512patrols
sacrals93311792sacrals
saffrons1444302saffrons
salols64017872sa_lols
santols73513322santols
sarods74918572sa_rods
saros55238062sa_ro_s
saurels749302saurels
sterols7313442sterols
across8312643_across
afrits9311903_afrits
aldols7109713_aldols
aprons8316993_aprons
argols74514613_argols
arils58732203_a_rils
arrows92813493_arrows
aryls87015813_a_ryls
astrals75515243astrals
aurous64119263_aurous
awols84713523_a_wols
babools11319453babools
barons85025383ba_rons
barrels94514363barrels
barrows123411693barrows
befools1236433befools
carfuls1249133carfuls
carls77037423ca_r_ls
carobs104818103ca_robs
carol75128613ca_rol_
caroli85918233ca_roli
carolus94612603ca_rolus
caroms105619573ca_roms
carrels95117303carrels
carroms11512403carroms
carrots9714623carrots
dacrons103211033dacrons
earfuls1036863earfuls
earls56127513ea_r_ls
enrols61213383_enrols
farfals13268503farfals
farfels13348213farfels
farls85731113fa_r_ls
faros85532023fa_ro_s
farrows13259793farrows
fools86824203__fools
froes86126693__froes
frogs96220773__frogs
frons86124043__frons
frows116623103__frows
gambols1238593gambols
gaols66717573ga__ols
garrons82713463garrons
hadrons113314303hadrons
harls85634503ha_r_ls
harrows132611043harrows
jarfuls1754773jarfuls
jarls126120963ja_r_ls
karoos102415803ka_roos
kaross101910013ka_ross
karroos1139313karroos
ladrons83813193ladrons
laurels746663laurels
macrons113514893macrons
macros104017013macro_s
maltols939403maltols
marls75535163ma_r_ls
marrons93216973marrons
marrows122911833marrows
matrons93517633matrons
narrows10258853narrows
natrons73215663natrons
nerols6914893_nerols
parol74826273pa_rol_
parole84425253pa_role
paroles95025883pa_roles
parous84024163pa_rous
parrals94414573parrals
parrels94713493parrels
parrots9312743parrots
patrol83213023patrol_
patrons93818103patrons
payroll1245613payroll
payrolls1344753payrolls
petrols92913083petrols
pyrrols1235403pyrrols
ramrods1036583ramrods
sabals84618863sa_bals
sabots8314703sa_bots
sabras85116363sabr_as
sabres85520863sabr_es
sacral83414413sacral_
sacrums11388043sacrums
sadirons936033sadirons
safaris101110663safaris
safely12249393saf_ely
safes85226723saf__es
saffron1344173saffro_n
sagos66123873sa_go_s
sailors73213723sailors
sails55738103sa__ils
sajous13310583sa_jous
salals65120083sa_lals
sallows103915553sallows
salmons93713263salmons
salol55222143sa_lol_
salons63823693sa_lons
saloons74415323saloons
saloops93510133saloops
sals46851673sa___ls
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salvo_s
sambals115213483sambals
sambos104315193sambo_s
samiels939763samiels
sandals82715203sandals
sanious7514103sanious
sannops936693sannops
santol64515243santol_
santos64421833santo_s
saporous1039053saporous
sapors84118813sa_pors
saprobe1137333saprobe
saprobes1237033saprobes
sapropels1343643sapropels
sarans64224433sa_rans
sarcous9312933sarcous
sards64736183sa_r_ds
sarees65329943sa_rees
sarges75128593sa_rges
sargos74318273sa_rgos
sarins63932623sa_rins
saris54544953sa_r_is
sarks96632463sa_r_ks
sarod65325873sa_ro_d
sarode75317513sa_rode
sarodes84216143sa_rodes
sarong73914873sa_rong
sarongs84511803sa_rongs
saroses73619333sa_roses
sartors7314973sartors
satoris7317253satoris
satraps95011643satraps
sauls55128123sa__uls
saurel6511993saurel_
sauries72821623sauries
saviors1058993saviors
savorous1146603savorous
savors95616103sa_vors
savoys12427893sa_voys
sawlogs1135393sawlogs
scabrous1245993scabrous
scaffold1742233scaffold
scaffolds1841573scaffolds
schools1249113schools
schorls1248353schorls
schrods1337433schrods
scrods94111613s_crods
scroll8310173s_croll
scrolls938063s_crolls
seafoods1245673seafoods
seafowls1443663seafowls
seafront1148023seafront
seafronts1244383seafronts
serous65023563s_erous
serows96016393s_erows
sheols94614163s_heols
shools94919013s_hools
shorls94516203shor_ls
skatols1135533skatols
skirls10449823skir_ls
snarls64016873snar_ls
snools65715883s_nools
sokols10399093s_okols
sols45448163s___ols
sorels63921163s_orels
sorrels7310723sorrels
sorrows10278403sorrows
sotols63714473s_otols
sparrows1344813sparrows
spirals93212513spirals
spools85115913s_pools
stanols739733stanols
sterol6613333sterol_
stools65117023s_tools
stroll6311603s_troll
strolls739183s_trolls
strops86220383s_trops
strows96718273s_trows
stroys95914603s_troys
swirls94010133swir_ls
symbols1435523symbols
tallols73311363tallols
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_ro_s
tarots66422993ta_rots
taxols13328633ta_xols
wadmols1333913wadmols
yarrows13277863yarrows

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272066.39320964.6
3Display Results2062060.0603433.3
 (SQL Overall)1786912066.85926052.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.