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

133 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
nandinas93657(None) 
nandina838911nandina_
nandins8312001nandin_s
anginas8310952_anginas
bandanas11178572bandanas
candidas12338642candidas
cantinas102713772cantinas
landings103110072landings
nandin7313032nandin__
nankins1159052nankin_s
angina7413133_angina_
anginal8310163_anginal
anhingas12104323_anhingas
animas84418723_an_imas
annas55824883_an__nas
annonas738793_annonas
anoints7311063_anoints
antings85015583_antings
audings9289393_audings
bananas93312223ban_anas
bandana10179463bandana_
bandannas12163283bandannas
bandas95120543band__as
bandies104124863bandi_es
bandiness122310243bandiness
banding114921413bandin_g
banditos11347633banditos
bandits103814793bandi_ts
bandoras1138743bandoras
banians9312033ban_ians
bankings15489403bankings
bindings123810463bindings
bondings12369413bondings
brandings13277483brandings
candelas1139533candelas
candida114110253candida_
candidal12367733candidal
candids113812693candi_ds
candies104125613candi_es
canines93724033can_ines
cannas84518403can__nas
cannings113710333cannings
cantina93417253cantina_
canzonas1935383canzonas
cardias10715093cardi_as
cardinal1139553cardinal
cardinals1247983cardinals
cardings123812623cardings
carinas93622383ca_rinas
cassinas103610633cassinas
dandies94121443dandi_es
eanlings9128463eanlings
encinas938723_encinas
endings92910443_endings
fadings12469303fa_dings
fanzines2036913fanzines
farinas103215233fa_rinas
findings13328433findings
fontinas1136853fontinas
handicap1644933handicap
handicaps1744083handicaps
handiness132110933handiness
handing123518893handin_g
handlings14237333handlings
hangings13258583hangings
jarinas143712183ja_rinas
kachinas1736333kachinas
katcinas1434513katcinas
ladings93814133la_dings
ladinos8389963la_dinos
laminas93615873la_minas
landing92819323landin_g
landlines1039753landlines
lantanas838263lantanas
latinas74416463la_tinas
mananas93414733man_anas
mandalas1139433mandalas
mandiocas1443943mandiocas
mandolas1139133mandolas
manias84029033man_i_as
manilas93915873man_ilas
mannas85019803man__nas
marinas93519373ma_rinas
medinas103411463_medinas
mendings12338293mendings
nadas66320813na_d__as
nadiral836343na_diral
nadirs7109003na_di_rs
naganas847983na_ganas
nairas6312773na__iras
nanas55928633na___nas
nancies93516843nanci_es
nanisms938833nan_isms
nankin1039673nankin__
nannies73015203nanni_es
napkins1336673napkin_s
nardine82712573nardin_e
nonfinal1147693nonfinal
paddings13297003paddings
pandanus1136433pandanus
pandas95521963pand__as
pandies104224503pandi_es
pandits103914213pandi_ts
pandoras11310053pandoras
panduras1136943panduras
pastinas103712153pastinas
patinas96318523pa_tinas
radians83013823ra_dians
randans8313213randan_s
randies84225663randi_es
randiness102511443randiness
rankings13389163rankings
rendzinas1941563rendzinas
salinas73116093sa_linas
sandiness102111713sandiness
sanding93520603sandin_g
sandlings11238093sandlings
sanidines1048043sanidines
sarcinas1039273sarcinas
sardanas937813sardanas
sardines92815563sardines
scandias1137863scandi_as
standings11257153standings
tankinis12245913tankinis
tannings9268633tannings
tannins72813223tannin_s
undines8716083_undines
vaccinas1544973vaccinas
vaginas11298813va_ginas
vandas103915993vand__as
waddings14356463waddings
windings13329963windings
zananas16319563zan_anas

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 Limit1461621336.37322934.6
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.59227107.3
 
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.