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

64 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
agamas9741345(None) 
agama85815581agama_
agmas85919871ag_mas
gamas85431361_gamas
abacas104414722abacas
abakas123911742abakas
abamps1236252abamps
abayas114011702abayas
abomas101113582abomas
agamic113110562agamic
agamid103710692agamid
agamids11317012agamids
agamous1037942agamous
agapae9388042agapae
agapai9456862agapai
agapes95212412agapes
agars66120642aga_rs
agas55938842ag__as
agates76121342agates
agaves104611512agaves
aggadas1055002aggadas
aghas97014872ag_has
agitas7310592agitas
agma77623262ag_ma_
agoras7613342agoras
agrias74315392agrias
alamos8415002alamos
almas76629772a_lmas
amas67746292__amas
anabas8314082anabas
animas84418722animas
arames84622572arames
argalas84011092argalas
aromas81018612aromas
asanas6514112asanas
asramas938302asramas
ataman81013062ataman
atamans9710432atamans
atmas75721012a_tmas
camas96333522_camas
dramas95814662dramas
galas65731642_galas
gama77035522_gama_
gamay116419112_gamay
gamays126310912_gamays
gambas115817512_gambas
gambs105721122_gambs
games86238552_games
gammas115714692gammas
gamps105323712_gamps
gams76648882_gam_s
gramas94317202gramas
lamas75532792_lamas
llamas888972llamas
magmas115512502mag_mas
mamas95930772_mamas
naganas847982naganas
ogams84112682ogam_s
pajamas18278152pajamas
panamas113112762panamas
sagaman10117562sagaman
shamas113717942shamas
taramas9612702taramas
ulamas8910452ulamas

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551642.54632423.8
3Display Results64640.0302133.3
 (SQL Overall)178691642.93660862.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.