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

117 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
valguses123423(None) 
vulguses1243501vulguses
arguses84711742_arguses
calluses1039322calluses
galluses936962galluses
taluses7311212tal_uses
valgus1047102valgu__s
valises103516262val_ises
valses94514612val__ses
values94314942val_u_es
valvules1443472valvules
varuses10310622va_ruses
walruses11554972walruses
abuses85119103_a_buses
accuses114112193_accuses
aegises8311373_aegises
agues64919053_a_gu_es
aldoses8311203_aldoses
algums9208043_algu_ms
aliases7914493_aliases
alludes83610333_alludes
allures72913113_allures
almuces11316823_almuces
almudes10418263_almudes
amuses85117943_a_muses
ankuses1148203_ankuses
anuses66218773_a_nuses
arcuses94814693_arcuses
argues74516413_argu_es
arouses74921293_arouses
avgases11106313_avgases
balases93815433bal_ases
ballutes1037523ballutes
blouses94014463_blouses
boluses94113833bol_uses
cactuses1237933cactuses
calloses10313393calloses
callouses1147683callouses
callused1135853callused
calques182710193calqu_es
campuses1437773campuses
cangues10611823cangu_es
carouses10614503carouses
caucuses1236783caucuses
causes88026473ca__uses
cayuses12188403ca_yuses
clauses93813323_clauses
coleuses1039723coleuses
cultuses1037753cultuses
delouses9310013delouses
dinguses1037643dinguses
favuses1336183fa_vuses
flatuses1137173flatuses
funguses1254713funguses
gallused1034193gallused
gangues9149753gangu_es
haggises1335883haggises
halituses1245573halituses
halluces1335613halluces
iambuses1235783iambuses
ileuses738673_ileuses
jalousies1643753jalousies
lagunes8148523la_gunes
langues81211913langu_es
louses66230283__louses
malaises10312333malaises
maltases1039693maltases
maltoses1039863maltoses
neguses837933_neguses
passuses1036773passuses
pauses84621473pa__uses
phalluses1444263phalluses
plagues103311063plagu_es
pluses83618073_pl_uses
radiuses937043radiuses
railbuses1143623railbuses
salutes73716253sal_utes
soleuses838073soleuses
tallises82713263tallises
thalluses1243903thalluses
vague96513113va_gu_e_
vaguer10448443va_gu_er
vaguest1137333va_guest
vagus96713813va_gu__s
valances1398763valances
valences1388513valences
vales85434263val___es
valines104520213val_ines
valise92917643val_ise_
valorises122210193valorises
valours10248743valou_rs
valse85117523val__se_
valuates112811203valuates
value85719093val_u_e_
valued104011153val_u_ed
valuer93911443val_u_er
valuers10328943val_uers
valutas1036533val_utas
valves124113783val__ves
valvule1343663valvule_
vamooses1345523vamooses
vamoses1239153va_moses
vases84626263va___ses
veloutes1136153veloutes
velures1039093vel_ures
venuses103111413v_enuses
virgules1244333virgules
viruses1039413v_iruses
vogues104011923v_ogu_es
volumes12298233vol_umes
volutes102710983vol_utes
vulgates12237233vulgates
vulgus1035783vulgu__s
vultures1137213vultures
wammuses1543493wammuses
wampuses1534113wampuses
wamuses1237023wa_muses

Search took 8 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.403443402.0
2DLD Change Limit1461621176.83021400.0
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.27924548.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.