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 “ambergrises” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

36 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
ambergrises166168(None) 
ambergris1452232ambergri__s
amberies122514683ambe__ri_es
aubergines1354273auberg_ines
advertises1445914adver_tises
aegises8311374a__e_g_ises
albertites1244874alber_tites
allegorises1283594allegorises
allergies10137784allerg_i_es
allergists1144214allerg_ists
ambaries123312384amb__ari_es
amberinas1344614ambe__rinas
amberoids1445334amber_oi_ds
ambries111614554amb___ri_es
amortises1178824am_or_tises
anergies9310454a_nerg_i_es
arrises71617584a___r_rises
auberges1146674auberg___es
aubergine1244764auberg_ine_
barberries1446234barber_ri_es
bayberries1744094bayber_ri_es
begrimes1376514__be_grimes
berberises1444904__berberises
berries94423554__ber_ri_es
derrises93012784__der_rises
energises1047064_energ_ises
enterprises1355544enterprises
hagberries1674244hagber_ri_es
liberalises1346834liberalises
memorises131211584_m_emorises
mercerises1446194_m_ercerises
merises93421424_m_e__rises
morrises10711074_m_or_rises
sherrises12156864_sher_rises
suberises11813454sube__rises
waxberries2243134waxber_ri_es

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 Filter1786911488190.423422437.4
2DLD Change Limit148819369.03016480.5
3Display Results36360.0331090.9
 (SQL Overall)178691369.48618837.3
 
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.