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

42 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
araroba94576(None) 
ararobas1046181ararobas
arroba898661ar_roba
algaroba1142032algaroba
arriba867682ar_riba
arrobas969212ar_robas
acaroid103512303acaroid
acerola947823acerola
acrobat11411813a_crobat
aerobat9514473a_erobat
aerobe8412403a_erobe
aerobia939463a_erobia
agarose838653agarose
algarobas1252243algarobas
algarroba125943algarroba
amarna839793amar_na
amarone9311193amarone
anaerobe1044823anaerobe
anaerobia1184113anaerobia
arabica1147283arabica
areola6813673ar_eola
aroma71220143__aroma
arrow83414883ar_ro_w
arrows92813483ar_rows
arrowy12288273ar_rowy
arroyo936963ar_royo
arugola844353arugola
aurora6411763a_urora
caramba1336893cara_mba
carob95325223_carob_
carobs104818103_carobs
crapola1136913crapola
dagoba1074943_dagoba
granola837913granola
malaroma1245583malaroma
parabola1246653parabola
paranoea1048553paranoea
paranoia10410563paranoia
ramona8412413_ramona
wardrobe1464133wardrobe
zareba1736423_zareba
zariba1736983_zariba

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027428.29616155.6
3Display Results42420.0162625.0
 (SQL Overall)178691428.46821101.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.