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

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

61 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
ulvas8451150(None) 
ulnas55716531ulnas
ulva75412691ulva_
vulvas12388841vulvas
alas46358122al_as
albas75925392albas
alfas87219042alfas
algas65624932algas
alias55834602alias
almas76629782almas
devas96218882devas
divas95418582divas
dulias71212742dulias
elves85118742elves
favas115618592favas
fleas86423662fleas
glias64618492glias
guavas1037162guavas
halvas124714172halvas
hulas84920882hul_as
javas155915422javas
kavas125919962kavas
kivas124614742kivas
kvas117015952_kvas
las37281472_l_as
lavas85422222lavas
lavs76734152_lavs
leas45954182_leas
lumas75622912lumas
lunas55025012lunas
luvs75818502luv_s
mullas84215932mullas
novas85215362novas
ollas54218282ollas
pleas75627032pleas
selvas93812912selvas
silvas92912182silvas
sulfas9311562sulfas
sylvas12288172sylvas
ulamas8910452ulamas
ulan46527392ul_an
ulans54921302ulans
ulemas888962ulemas
ulna46317332ulna_
ulnad65611452ulnad
ulnae55214572ulnae
ulnar56013982ulnar
ulpan7310122ulpan
ultras6310192ultras
ulus45622562ul_us
upas68322382u_pas
ureas55826012ureas
utas45924952u_tas
uveas84912282uveas
vas67755772__vas
vivas114815022vivas
volvas12447992volvas
vulva11448802vulva_
vulvae12438032vulvae
vulval12417662vulval
vulvar12427962vulvar

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit53800612.14325105.0
3Display Results61610.0163812.5
 (SQL Overall)178691612.46972373.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.