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

201 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
spartina103798(None) 
spartinas1135791spartinas
parting103527382_parting
partita9310862_partita
pastina93914592_pastina
patina86022192_pa_tina
sarcina9310732s_arcina
scarting113415262scarting
smarting113212452smarting
sparging122611132sparging
sparing104823872spar_ing
sparking152812532sparking
sparling112714522sparling
sparring113112222sparring
spartan948332spartan_
sparteine1185482sparteine
spatting113111762spatting
spirting112913632spirting
sporting112415462sporting
spurting113111632spurting
starting93116172starting
cantina93417253_cantina
carina84325323_car_ina
carting104228283_carting
charting142614193charting
cortina91915963_cortina
czarina1845953czar_ina
darting94020663_darting
departing1349513departing
disparting1438933disparting
farina94618233_far_ina
farting114120753_farting
hearting12513123hearting
imparting1437243imparting
jarina134014063_jar_ina
karting123716063_karting
latina65621143_la_tina
marina84623413_mar_ina
martian93514683_martian
martin84122523_martin_
marting103325013_marting
martini93613873_martini
martins93322063_martins
misparting1538083misparting
ocarina948023ocar_ina
panting104025423_panting
pardine103616723_pardine
pareira937533_pareira
parging113318603_parging
parian83223963_par_ian
paring94236493_par_ing
parking143423043_parking
parling103823763_parling
parring103222063_parring
parsing103819553_parsing
partan83820563_partan_
partans94418283_partans
partial92616263_partial
partied103516553_partied
partier93520713_partier
parties93230863_parties
partings113513733_partings
partisan1058423_partisan
partitas10310253_partitas
partite9317133_partite
partizan1955643_partizan
parton84720993_parton_
partons94620513_partons
partying14168893_partying
pastinas103712153_pastinas
pasting103826553_pasting
patin76832853_pa_tin_
patinae95414403_pa_tinae
patinas96318523_pa_tinas
patine85328123_pa_tine
patins87528783_pa_tins
patting103722343_patting
platina94413643_platina
porting103021783_porting
prating103424453_prating
salina64221123s_a_lina
saltine75018563s_altine
salting84120793s_alting
sarcinae1047193s_arcinae
sarcinas1039273s_arcinas
sardana838643s_ardana
sardine83317393s_ardine
sarin55239253s_ar_in_
sarins63932623s_ar_ins
satin55935213s_a_tin_
sating74735453s_a_ting
satins64930483s_a_tins
satiny93817983s_a_tiny
scanting113914763scanting
scarfing14309713scarfing
scaring103421973scar_ing
scarlatina1294053scarlatina
scarping133312463scarping
scarring112511513scarring
scatting113311813scatting
searing83330923sear_ing
seating84130683sea_ting
separating1348643separating
sestina72711973s_estina
shafting15278673shafting
sharia93116723shar_i_a
sharing113723243shar_ing
sharking163912973sharking
sharping143011373sharping
shirting123213603shirting
shortia1048173shorti_a
shorting122514793shorting
skating123613843ska_ting
skirting13289393skirting
slanting94115093slanting
slating83724653sla_ting
slatting94014233slatting
smaltine1037833smaltine
smarten9348863smarten_
smartens10286663smartens
smartie9310163smarti_e
smarties10312873smarties
snarfing12358663snarfing
snaring83920953snar_ing
snarling92513183snarling
snorting92613373snorting
soaring83521893soar_ing
sonatina849073sonatina
sorting83221813s_orting
spacing123614493spa_cing
spading113114383spa_ding
spaeing103413543spa_eing
spalling113213463spalling
spamming15317603spamming
spanking153911973spanking
spanning113311083spanning
sparid94016933spar_i_d
sparids103512123spar_ids
sparkier14298023sparkier
sparkily1735013sparkily
sparkish17276973sparkish
sparkling16226343sparkling
sparlike1437663sparlike
sparlings12257143sparlings
sparoid102311533sparoi_d
sparoids11218713sparoids
sparrier10329143sparrier
sparsity1345463sparsity
sparteines12105173sparteines
spasming13227203spasming
spastic11310373spasti_c
spastics1237503spastics
spatial9310323spa_tial
spatula935893spa_tula
spavin114210653spa_vin_
spavins12419323spa_vins
spawning14296913spawning
spaying133014623spa_ying
spearing113216103spear_ing
spearmint1365983spearmint
spermine12311433spermine
spiring103918183spir_ing
spiriting1238413spiriting
spirulina1143423spirulina
spiting103917623sp_iting
spitting113012323spitting
splatting1235983splatting
sporing104319413spor_ing
sportier102010053sportier
sportif1238793sporti_f
sportily1337733sportily
sportive1348333sportive
spotting112812083spotting
spouting113511953spouting
sprain83614863sp_rain_
sprains93013593sp_rains
spraying14299883spraying
spring94526013sp_r_ing
sprint84526793sp_r_int
spurning11258663spurning
spurring11339763spurring
stamina9310793sta_mina
staring84527053star_ing
starling93017123starling
starring92312953starring
startling1037373startling
starving122510173starving
statin63921463sta_tin_
stating83725163sta_ting
statins73719773sta_tins
swarding1359003swarding
swarming1458223swarming
swastica1384153swastica
swastika1591853swastika
swatting12309593swatting
tartana73010193_tartana
tarting84222653_tarting
tsarina736653tsar_ina
tzarina1635053tzar_ina
updarting1334333updarting
uprating11311113uprating

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622016.65621959.4
3Display Results2012010.0762644.7
 (SQL Overall)1786912016.88825942.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.