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 “staminal” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
staminal104698(None) 
stamina9310791stamina_
staminas1048851staminas
stamineal1143101stamineal
laminal94113632_laminal
seminal91213402s_eminal
staminate1187982staminate
statical1039422statical
stational948502stational
atomical1248903atomical
basinal9310033_basinal
carinal94318223_carinal
criminal1248303criminal
estaminet1149693estaminet
etamin81311853etamin__
etamine91313063etamin_e
etamines101611793etamines
etamins91511823etamin_s
foraminal1444263foraminal
geminal10109893_geminal
germinal1147253germinal
imaginal1144903imaginal
lamina84920443_lamina_
laminae93512973_laminae
laminals10339303_laminals
laminar93810283_laminar
laminas93615873_laminas
liminal93810673_liminal
luminal93711003_luminal
matinal9312603_matinal
nominal92712373_nominal
paginal10269493_paginal
putamina1244543putamina_
ruminal9289993_ruminal
sahiwal1344443s_ahiwal
salina64221123s_alina_
salinas73116093s_alinas
sambal105215183s_am_bal
samiel8313333s_ami_el
satanical1145413satanical
seaming103222113seamin_g
seasonal847263seasonal
semina8915563s_emina_
seminar979753s_eminar
shaming133016743shamin_g
somital939403s_omital
spacial1138763spaci_al
spatial9310323spati_al
spinal84915313s__pinal
stadia7312143stadi_a_
stadias8411113stadi_as
staging93818373stagin_g
stagings10378343stagings
stain55727933sta_in__
stainable1138093sta_inable
stained84215343sta_ined
stainer73614923sta_iner
stains64923653sta_in_s
staking123919803stakin_g
staling83925423stalin_g
stamen84115943stamen__
stamened1137633stamened
stamens93411483stamen_s
staminode1242653staminode
staminody1541743staminody
stammel11607533stam_mel
stamping133310963stampin_g
stanine73417073stanin_e
stanines85115663stanines
staning83922243stanin_g
stanol6310723sta__nol
staring84527053starin_g
staringly1337963staringly
stasima955633stasima_
statal61613223sta__tal
statin63921463statin__
stating83725163statin_g
statins73719773statin_s
staving113915703stavin_g
staying114017323stayin_g
steaming114013213steamin_g
sterical10311243sterical
sternal73411903st_ernal
stibial946583stibi_al
stoical9310273st_oical
stomal85213313stom__al
stomatal1045823stomatal
summital1244703summital
tamal73522613_tam__al
taming94023433_tamin_g
tarnal63716503_ta_rnal
tegminal1144453tegminal
terminal1039723terminal
trinal6516953_t_rinal
tsarina736653tsarina_
tsarinas835273tsarinas
vaginal11288403_vaginal
viminal12288823_viminal

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 Limit146162988.56317069.0
3Display Results98980.0462130.4
 (SQL Overall)178691988.76520386.9
 
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.