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

67 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
solleret851222(None) 
soleret7321231so_leret
sollerets945261sollerets
collaret103116702collaret
hollered1237602hollered
soldered1038152soldered
solderer947182solderer
solerets839692so_lerets
cellaret103713573cellaret
collared113211143collared
collarets11327333collarets
collect113314593colle_ct
colleen939543colle_en
college102410443college_
colleger11227933colleger
colleges112410523colleges
collet84030363coll__et
colleted113011663colleted
dosseret91111513dosseret
floweret1448083floweret
fullered1236383fullered
holler93520613holler__
hollers103818233holler_s
loller63315283loller__
lollers72713793loller_s
moldered1237173moldered
pollee83623273polle_e_
pollees93215333polle_es
pollened1157783pollened
poller83921853poller__
pollers93420023poller_s
roller63919793roller__
rollers73117473roller_s
sallet63734543sall__et
seller63824603seller__
sellers73721323seller_s
siller64026063siller__
sillers73822103siller_s
silvered12237563silvered
silverer11216733silverer
sleet55639133s__le_et
smoldered1343793smoldered
sobered102912433so_bered
soberer93110353so_berer
soberest10310353so_berest
soilure736233soilure_
soilures836503soilures
solder73921343solder__
solderers1066533solderers
solders83517773solder_s
soldiered1143763soldiered
solfege1144223solfege_
solfeges1244083solfeges
solvent10310833solve_nt
solver94016703solver__
solvers104414253solver_s
somerset10411073so_merset
sorcerer1036433sorcerer
sulfuret1149273sulfuret
sullener857243sullener
sullenest9410213sullenest
tillered937443tillered
toller63819443toller__
tollers73217463toller_s
velveret1447043velveret
volleyed1543533volleyed
volleyer1443163volleyer

Search took 9 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.420425454.8
2DLD Change Limit146162677.65619091.2
3Display Results67670.0332030.3
 (SQL Overall)178691678.10922036.1
 
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.