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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
valse8511752(None) 
false84818121false
vale74937341val_e
vales85434261vales
valise92917651valise
valses94514611valses
value85719091value
valve114515931valve
vase75629651va_se
aals49941142aals_
alae45643752_alae
ale36572342_al_e
alee46652322_alee
ales47067102_ales
alme65832162_alme
aloe45540192_aloe
als36663022_als_
also46423442_also
apse67725382_apse
arse46539272_arse
avulse935842avulse
bale66353842bal_e
bales76250082bales
bals66354042bals_
balsa77920412balsa
base64847022ba_se
blase75524232blase
calve105919922calve
carse74934332carse
case65848082ca_se
cause75225352cause
dale55643982dal_e
dales66439742dales
dals57145122dals_
dulse65415042dulse
ease45042332ea_se
else45923082_else
evulse935212evulse
falser93912412falser
falsie93513852falsie
gale56347322gal_e
gales65442482gales
gals57946502gals_
hale76052832hal_e
hales85449842hales
halve114818922halve
hanse85722792hanse
hawse116015122hawse
kale86533762kal_e
kales95730982kales
lapse74917682lapse
lase46148512la_se
male66052302mal_e
males75049792males
manse75528232manse
marse76231152marse
masse75125292masse
ovals85413392ovals_
paise75028332paise
pale66055012pal_e
pales75753802pales
pals66951352pals_
palsy105417462palsy
parse75236992parse
pase65346862pa_se
passe75525692passe
pause75021832pause
pulse74219972pulse
raise54828052raise
rale45050562ral_e
rales54947492rales
rase46149982ra_se
sale44959702sal_e
sales56055592sales
sals46851672sals_
salsa56718922salsa
salve85022132salve
tale46154162tal_e
tales55451372tales
tasse54821842tasse
tawse85616502tawse
vacs96226202vacs_
vadose1037962vadose
vague96513112vague
vails85825932vails_
valet84337872valet
valid94618392valid
valine94623092valine
valises103516272valises
valley124311602valley
valor83614892valor
valued104011152valued
valuer93911442valuer
values94314942values
valved136711042valved
valves124113782valves
vamose1159282vamose
vane75534692va_ne
vanes85130982vanes
vans76236742vans_
vars75742072vars_
varve115716852varve
vas67755772va_s_
vasa76522972va_sa
vases84626262va_ses
vast75045122va_st
vats76841742vats_
vaus75928922vaus_
vavs105720432vavs_
vaws105527322vaws_
veals84926192veals_
verse84723582verse
vials85822382vials_
vile76139812vil_e
vise75632682v_ise
vole75236982vol_e
voles86234042voles
volte85321302volte
wale74546442wal_e
wales86142842wales

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.330541487.9
2DLD Change Limit538001201.57634137.1
3Display Results1201200.0333636.4
 (SQL Overall)1786911201.93992156.3
 
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.