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

48 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
bolognas114407(None) 
bologna1044251bologna_
colognes11310602colognes
apologias1247503apologias
belgas9311713bel_g_as
belongs10408223belo_ngs
belons84119413belo_n_s
belugas1035903belug_as
biogas94310913b_iog_as
biologics1446863biologics
biologies12311183biologies
blogs85319233b_log__s
blonds95213343b_lo_nds
bodegas1135483bodeg_as
bogans95714813b__ogans
bolas74733763bol___as
bolivias1345393bolivias
bolograph1767293bolograph
bolographs1867533bolographs
boloney1247763bolo_ney
boloneys1334503boloneys
bolos75531373bolo___s
bolsons969483bolson_s
boltonias1145123boltonias
boogers104514633bo_ogers
boogeys13476873bo_ogeys
boogies103719013bo_ogies
boons75031913bo_o_n_s
borons85520543boro_n_s
bosons85016653boso_n_s
brogans1049663b_rogans
cologne1039353cologn_e
cologned1237153cologned
cologs96517353colog__s
colones96124433colo_nes
colons86028683colo_n_s
colonus94413443colo_nus
coronas93916913coro_nas
eulogias946553eulogias
hologram1448103hologram
holograms1547363holograms
logans76319063__logans
oblongs1033533oblo_ngs
ologies8615023_ologies
oologies9312993oologies
oolongs845953oolo_ngs
slogans8407983_slogans
solons65120023solo_n_s

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.1531167915.0
2DLD Change Limit146162487.26620115.9
3Display Results48480.0163000.0
 (SQL Overall)178691487.43524033.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.