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

80 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
rasbora94594(None) 
rasboras1045891rasboras
carbora11310702carbora
aboma91114603_a_boma
aboral8314373_a_boral
abort76133583_a_bort
absorb1038013_absorb
agora6914333_a_gora
angora71111573_angora
arbor74818113_arbor_
arbors84717883_arbors
ashore9414613_ashore
assort64916383_assort
aurora6411763_aurora
balboa10389963balbo_a
bandora1038813bandora
baseborn1244453baseborn
bora66141633___bora
carboras12311583carboras
cascara1138313cascara
castor84418533castor_
castors94919443castors
diaspora1154403diaspora
drawbore1442673drawbore
hagborn1344953hagborn
harbor11410723harbor_
harbors12412413harbors
labara83712893la_bara
labor75117313la_bor_
labors84016413la_bors
labra75415463la_b_ra
lastborn1044133lastborn
mascara1138023mascara
pakora1247283pa_kora
pandora1039543pandora
pastor84817483pastor_
pastoral10310483pastoral
pastors94119003pastors
rabboni1144803rabboni
ragwort11510733ragwort
rambla103510933ramb_la
ramona8412413ra_mona
ramshorn1343923ramshorn
rancor8810373rancor_
rancors9811373rancors
rapport11311223rapport
raptor83912823raptor_
raptors94213353raptors
raser55633413ras_er_
rasers64526783ras_ers
rasher95024123rasher_
rashers104020913rashers
rasorial848223ras_orial
rasper83917333rasper_
raspers94415923raspers
raster64731443raster_
rasters74629023rasters
rasure6311423ras_ure
razor143012603ra_zor_
razors154711663ra_zors
reabsorb1243353reabsorb
reassort8410683reassort
rebore86625643r_ebore
reborn810016953r_eborn
remora8414583r_emora
rescore95616193rescore
resorb84914343res_orb
resort65728613res_ort
restoral8810983restoral
restore75822973restore
rhodora1144293rhodora
ristra6310713ris_tra
roseola777053roseola
rostra6310933ros_tra
sabra75317853sa_b_ra
sora45746913__s_ora
tabor75518393ta_bor_
tabors84517113ta_bors
tamboura1253893tamboura
tambura11326463tambura

Search took 7 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.1401276364.3
2DLD Change Limit134027806.78019768.0
3Display Results80800.0332424.2
 (SQL Overall)178691806.95325699.8
 
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.