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
sarcinas103927(None) 
sarcina9310731sarcina_
sarcinae1047191sarcinae
carinas93622402car_inas
farinas103215232far_inas
jarinas143712182jar_inas
katcinas1434512katcinas
marinas93519382mar_inas
sacrings11278922sacrings
salinas73116092sa_linas
sarcomas1247222sarcomas
sardanas937812sardanas
sardines92815562sardines
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
arginase946433_arginase
arias55438023_ar_i_as
armings103811503_armings
arnicas939543_arnicas
aroints7313133_aroints
arsines73518813_arsines
barcas101016603barc__as
barchans1588683barchans
bracings13369293bracings
calcines12314753calcines
cantinas102713773cantinas
carbines123617533carbines
carcinomas1643723carcinomas
cardias10715113cardi_as
cardinal1139563cardinal
cardinals1247993cardinals
cardings123812633cardings
carina84325323car_ina_
carinae94318583car_inae
carinal94318233car_inal
caritas93316953car_itas
carlines103521643carlines
carlings114015853carlings
carlins93921913carlin_s
carmines123617863carmines
carpings133812383carpings
carvings143810203carvings
cassinas103610633cassinas
corbinas12229393corbinas
cortinas102212443cortinas
corvinas13238013corvinas
czarinas1935293czar_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
marginal1137603marginal
marginals1246003marginals
margins103815193margin_s
marina84623413mar_ina_
marines93928013mar_ines
markings153410243markings
marlines103818713marlines
marlings113713493marlings
marlins93420473marlin_s
martians103111613martians
martinis103311613martinis
martins93322063martin_s
nandinas936573nandinas
narceines1146583narceines
narceins1036413narcein_s
narcisms1267263narcisms
narcists1078113narcists
narcomas1246043narcomas
ocarinas1036723ocar_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
sereins73716113serein_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 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.1561145455.1
2DLD Change Limit1461622188.25017716.6
3Display Results2182180.0802725.0
 (SQL Overall)1786912188.48621057.2
 
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.