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

61 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
amberina124739(None) 
amberinas1344611amberinas
amberies122514682amberies
amboina1137962amb_oina
cambering16109872cambering
umbering1399432umbering
abelia83114403a_beli_a
abelian92810643a_belian
adhering1338883adhering
algerine9810283algerine
altering91917113altering
amarna839793am_ar_na
ambari103012173ambari__
ambaries123312383ambaries
ambaris113112163ambari_s
amber94523213amber___
amberoid1346433amberoid
amberoids1445333amberoids
ambers104519583amber__s
ambery133811133amber__y
ambling121411793amb_ling
amboinas1246033amb_oinas
amboyna1443683amb_oyna
ambries111614553amb_ries
amercing1337193am_ercing
amnesia938293amnesi_a
amorini9310353am_orini
amorino9310253am_orino
amrita8411133am__rita
angering102113803angering
anserine8313093anserine
apteria9312913apteri_a
asteria7316183asteri_a
aubergine1244763aubergine
ballerina1146483ballerina
barbering14229683barbering
chambering20116043chambering
clambering1776163clambering
cumbering16108203cumbering
emerita938713em_erita
hammering1737633hammering
hampering1738863hampering
imperia1148423imperi_a
jabbering2134443jabbering
limbering1488793limbering
lumbering14117933lumbering
mammering1337333mammering
marina84623413_m_arina
medina94114093_m_edina
merino8315093_m_erino
numbering14107003numbering
pampering1638383pampering
sabering112113743sabering
sobering111912783sobering
suberin9314563suberin_
suberins10315093suberins
tabering112211423tabering
tampering1438453tampering
timbering14117723timbering
yabbering1734023yabbering
yammering1735193yammering

Search took 8 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.483369960.7
2DLD Change Limit146162617.17320376.7
3Display Results61610.0134692.3
 (SQL Overall)178691617.66923300.4
 
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.