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

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
agametes114729(None) 
agamete1037391agamete_
gametes10312251_gametes
agates76121332aga__tes
agemates111110022agemates
gamete9313592_gamete_
oogametes12174632oogametes
abamperes1563023abamperes
abates85825033aba__tes
academes1344873academes
accretes1238113accretes
adamsites1243513adamsites
agamas97413443agam__as
agamids11317003agam_ids
agamous1037923agam_ous
agapes95212413aga__pes
agaroses938823agaroses
agate66525143aga__te_
agatizes1838863agatizes
agaves104611513aga__ves
agemate101210583agemate_
agenes74720253ag__enes
ageneses939303ageneses
agitates9310873agitates
aglets73915683ag_let_s
agnates82813183ag_nates
agrees74915323ag_re_es
aguacates1244583aguacates
alamedas1145443alamedas
alamodes1148013alamodes
alates64833963ala__tes
algometer1246533algometer
algometers1345993algometers
ammeter1148393a_mmeter
ammeters1237693a_mmeters
analytes11169203analytes
anamneses1144613anamneses
animates101316423animates
apatites10311283apatites
arames84622573aram__es
aretes64425353__aretes
armets84918353a_rmet_s
athletes1157883athletes
calamites13410703calamites
catamites1349363catamites
diabetes1147023diabetes
diameter1148053diameter
diameters1247583diameters
egalites9310503egalites
gaieties9310183_gaieties
galeres83514323_galeres
galettes93111153_galettes
gambes116318313_gam_bes
gambles124016203_gambles
gameness112810693_gameness
gamers94420823_game_rs
games86238553_gam__es
gamester1137323_gamester
gamesters1236733_gamesters
gametal1037603_gametal
gametic1239983_gametic
gamines103618463_gamines
gamuts958783_gamut_s
garotes8614563_garotes
gates65939503_ga__tes
gayeties1236883_gayeties
gazettes18296863_gazettes
gemotes103712143_gemotes
hamates122917673_hamates
imamates1237653imamates
isogametes1352853isogametes
malamutes1345373malamutes
mameyes14376983_mameyes
megagametes1751943megagametes
metes74736213___metes
oogamete11184933oogamete_
parameter1349123parameter
parameters1448113parameters
ramees84620893_rame_es
ramets83517393_ramet_s
sagamores1244183sagamores
samites93118713_samites
siameses1036403siameses
tagmemes1342833tag_memes
zoogametes2252433zoogametes

Search took 10 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.1701051123.5
2DLD Change Limit146162859.04616157.6
3Display Results85850.0461847.8
 (SQL Overall)178691859.26219292.9
 
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.