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

84 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
velamina134566(None) 
lamina84920442__lamina
melamine12310302melamine
velamen1237122velamen_
velaria1038922velari_a
alumina9510053_alumina
beaming123618803be_aming
belaying143110603belaying
benaming1339693benaming
blaming123515693_blaming
calamine12314033calamine
calamint12315133calamint
defaming15238463defaming
delaine8314793dela_ine
delaminate1347373delaminate
delating103119603delating
delaying133210973delaying
deliming12310373deliming
elain55324703_ela_in_
elains64919853_ela_ins
elapine9310673_elapine
elating83423083_elating
enamine91214313_enamine
etamin81311853_etamin_
etamine91313073_etamine
etamins91511833_etamins
examine161510033_examine
flaming134216443_flaming
foramina1346163foramina
gelatin83514733gelatin_
gelatine93213303gelatine
gelating103015733gelating
gelatins93414093gelatins
germina1038493ge_rmina
gleaming12277933gleaming
helming133712003hel_ming
hexamine2046873hexamine
ketamine14157053ketamine
lamia75324323__lami_a
laminae93512973__laminae
laminal94113633__laminal
laminar93810283__laminar
laminas93615873__laminas
laming94528363__laming
latina65621143__latina
limina83514503__limina
lumina84613543__lumina
melamines1339763melamines
melanian1048483melanian
melanin9310893melanin_
melanins10310383melanins
platina94413643_platina
putamina1244543putamina
reaming103924013re_aming
relacing112516043relacing
relating92725443relating
relaxin14239183relaxin_
relaxing162612633relaxing
relaxins15248683relaxins
relaying122515153relaying
relumine1038933relumine
reluming11310013reluming
renaming11313693renaming
seaming103222113se_aming
semina8915563se__mina
stamina9310793_stamina
teaming103917593te_aming
tegmina1035243te_gmina
tegumina1143283tegumina
telamon936523telamon_
vagina102710933v__agina
vealing114217423ve_aling
vedalia1145683vedali_a
velarium1347073velarium
velarize2048763velarize
veluring1237563veluring
venoming1436403venoming
vermian12329713ve_rmian
vermin113414523ve_rmin_
vimina11339943v__imina
vitamin1237423vitamin_
vitamine1347373vitamine
vitamins1347083vitamins
voluming1435043voluming

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.1731032896.0
2DLD Change Limit146162849.45315462.0
3Display Results84840.0332545.5
 (SQL Overall)178691849.65918499.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.