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

218 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
sarcinas103928(None) 
sarcina9310731sarcina_
sarcinae1047191sarcinae
carinas93622412car_inas
farinas103215242far_inas
jarinas143712192jar_inas
katcinas1434512katcinas
marinas93519392mar_inas
sacrings11278922sacrings
salinas73116092sa_linas
sarcomas1247222sarcomas
sardanas937822sardanas
sardines92815572sardines
sarins63932622sar_in_s
spartinas1135792spartinas
tsarinas835272tsar_inas
vaccinas1544972vaccinas
acinar8310483_a_cinar
acinus8311253_a_cinus
anginas8310953_anginas
arcana8912583_arcana_
archines133815253_archines
archings14499863_archings
arcing95819643_arcin_g
arcsines104010343_arcsines
arenas65021993_ar_enas
arginase946443_arginase
arias55438023_ar_i_as
armings103811503_armings
arnicas939543_arnicas
aroints7313133_aroints
arsines73518813_arsines
barcas101016603barc__as
barchans1588683barchans
bracings13369293bracings
calcines12314753calcines
cantinas102713783cantinas
carbines123617543carbines
carcinomas1643723carcinomas
cardias10715123cardi_as
cardinal1139573cardinal
cardinals1248003cardinals
cardings123812643cardings
carina84325333car_ina_
carinae94318593car_inae
carinal94318243car_inal
caritas93316963car_itas
carlines103521653carlines
carlings114015863carlings
carlins93921923carlin_s
carmines123617873carmines
carpings133812393carpings
carvings143810213carvings
cassinas103610643cassinas
corbinas12229403corbinas
cortinas102212453cortinas
corvinas13238023corvinas
czarinas1935303czar_inas
darings93713653dar_ings
darlings103710383darlings
darnings10378553darnings
dracenas1145793dracenas
earings84517713ear_ings
earnings9419333earnings
earrings9299633earrings
encinas938723_encinas
facias113415803fa_ci_as
facings134511263fa_cings
farcical1546953farcical
farcies125317883farci_es
farcing133514003farcin_g
farina94618233far_ina_
farinhas14325363far_inhas
farmings14298223farmings
fascias1258413fasci_as
fascines13310143fascines
garcons102411643garcon_s
harianas1139163harianas
harmines132715143harmines
harmins123716723harmin_s
harpings14379773harpings
harpins123615703harpin_s
jacanas1638263ja_canas
jarina134014063jar_ina_
kachinas1736343kachinas
kartings13418523kartings
katchinas1843923katchinas
katcina1345153katcina_
lacings105013653la_cings
lacunas9138173la_cunas
laminas93615873la_minas
latinas74416463la_tinas
marginal1137613marginal
marginals1246013marginals
margins103815193margin_s
marina84623413mar_ina_
marines93928013mar_ines
markings153410243markings
marlines103818713marlines
marlings113713493marlings
marlins93420473marlin_s
martians103111613martians
martinis103311613martinis
martins93322063martin_s
nandinas936583nandinas
narceines1146583narceines
narceins1036413narcein_s
narcisms1267263narcisms
narcists1078113narcists
narcomas1246043narcomas
ocarinas1036733ocar_inas
orcins83313433_orcin_s
pareiras1038183pareiras
pargings123410163pargings
parians93519733par_ians
parings104219213par_ings
parkings153610683parkings
partings113513733partings
partitas10310253partitas
pastinas103712153pastinas
patinas96318523pa_tinas
piscinas1275483piscinas
porcinis1246953porcinis
racings105015133ra_cings
sabines94318483sa_bines
sabins85521983sa_bin_s
sackings15389633sackings
sacring103115983sacrin_g
sacrists1039563sacrists
saigas74114293sa__igas
sailings93513253sailings
saimins9312113saimin_s
sains55639973sa__in_s
saints65122423sa__ints
salicines11310003salicines
salicins10310933salicin_s
salina64221123sa_lina_
salines74029413sa_lines
salivas10309603sa_livas
salpians1036763salpians
saltines82917793saltines
saltings92811253saltings
salvias10279933salvi_as
saphenas1345713saphenas
saplings11269803saplings
sarans64224433sar_an_s
sarcasm1136693sarc__asm
sarcasms1244983sarcasms
sarcenet10413313sarcenet
sarcenets1146953sarcenets
sarcoids1137803sarcoids
sarcoma1147403sarcoma_
sarcous9312933sarc_ous
sardana838643sardana_
sardine83317393sardin_e
sardined10268663sardined
sardius839553sardi_us
sarin55239253sar_in__
saris54544953sar_i__s
sarments10311963sarments
sarongs84511803sar_ongs
sarsens7311393sarsen_s
sasins64923103sa_sin_s
satins64930483sa_tin_s
sauciers1076733sauciers
sauciness1138043sauciness
saucing10311003saucin_g
saunas63915433sa__unas
saurians837763saurians
savannas1143733savannas
savines104417633sa_vines
savings114412953sa_vings
savins93923133sa_vin_s
sayings113610833sa_yings
scenas84114703s__cenas
sereins73716123serein_s
sergings10299213sergings
sericins10312463sericin_s
serines74229543ser_ines
seringas9339003ser_ingas
serins64029673ser_in_s
servings12249223servings
sestinas8249133sestinas
sharias102516003shar_i_as
shrines104618693shr_ines
shrinks14397913shr_inks
soarings93210393soar_ings
sordines92414073sordines
sorings83817253sor_ings
spacings13287043spacings
sparlings12257153sparlings
spartina1037983spartina_
sprains93013593sprain_s
springs104415923spr_ings
sprints94113773spr_ints
staminas1048853staminas
starlings10237923starlings
strains74218153strain_s
strings84617133str_ings
surfings12268073surfings
syringas12285953syr_ingas
tacrines10310563tacrines
tarsias74013373tarsi_as
tartanas8258893tartanas
tracings112910413tracings
tsarevnas1241073tsarevnas
tsarina736653tsar_ina_
tzarinas1733973tzar_inas
vaccina1435303vaccina_
vaccinal1544903vaccinal
vaccines1536503vaccines
vaccinias1643283vaccinias
vaginas11298813va_ginas
varias95019903var_i_as
varmints1335643varmints
varnas94212823var__nas
warnings12358453warnings
zaribas1836043zar_ibas

Search took 10 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 Limit1461622188.58017035.2
3Display Results2182180.0932344.1
 (SQL Overall)1786912189.09319651.5
 
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.