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

85 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
yugas9501206(None) 
yogas96615601yogas
yucas106013911yucas
yuga85615421yuga_
agas55938842_agas
ajugas1435262ajugas
algas65624932algas
angas65827982angas
auras55932552auras
avgas96912132avgas
bugs76035912bug_s
bunas75126572bunas
buras74736292buras
degas75119162degas
dugs614832282dug_s
dumas85420432dumas
duras65727722duras
fugal95613032fugal
fugs85730692fug_s
fugus95914012fugus
gas48870252__gas
gigas75415582gigas
hugs86129752hug_s
hulas84920882hulas
jubas144614222jubas
judas134911882judas
juga126417322juga_
jugal135612402jugal
jugs125525602jug_s
luges65928752luges
lugs55233522lug_s
lumas75622912lumas
lunas55025012lunas
muggs94912322muggs
mugs76232042mug_s
muras75329562muras
outgas7313202outgas
pugs76332772pug_s
pujas145513322pujas
pumas95121562pumas
punas74826752punas
pupas95219282pupas
quags154613252quags
ragas65326062ragas
ruga56121232ruga_
rugae65114762rugae
rugal65916092rugal
rugs56033682rug_s
sagas66025882sagas
subas74724072subas
sugar6312912sugar
sugars7312422sugars
sughs95313322sughs
suras55336322suras
syngas10368912syngas
togas67823002togas
tubas75119572tubas
tufas85314382tufas
tugs56231672tug_s
tunas54224122tunas
ughs85410972_ughs
upas68322382_upas
utas45924952_utas
vigas94817882vigas
vuggs10579132vuggs
vughs12678742vughs
vugs87022872vug_s
yagis95416572yagis
yags86632292yag_s
yeas78638422y_eas
yeggs10608162yeggs
yoga87418052yoga_
yoghs125410592yoghs
yogis95617742yogis
yuan76120012yu_an
yuans84613322yuans
yuca95716722yuca_
yuccas13426552yuccas
yucks144717192yucks
yuks116418022yu_ks
yulan8411492yulan
yulans958672yulans
yules84521582yules
yups96121602yu_ps
yurts87216532yurts

Search took 2 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.0931921408.6
2DLD Change Limit53800851.75030742.9
3Display Results85850.0165312.5
 (SQL Overall)178691851.85996122.1
 
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.