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 “dayglow” 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
dayglow154184(None) 
dayglows1641951dayglows
aglow94711972_a_glow
airglow1143673airglow
allow85420663_a_llow
alow75328593_a__low
anglo65215373_anglo_
anglos74413913_anglos
barlow112911423ba_rlow
callow114714663ca_llow
daggle93711903daggl_e
daggled11329463daggled
daggles103611913daggles
daglock1544263da_glock
dago65725093da_g_o_
dagos76419443da_g_os
dangle84119303dangl_e
dangled104013153dangled
dangler96912813dangler
dangles93618423dangles
dangly114212263dangl_y
daybook1744373daybook
dayflower1942543dayflower
dayfly1633813dayfl_y
daylit10512493day_lit
daylong1233973day_long
dayroom1345233dayroom
diglot83014333d_iglot
drylot1037403dry_lot
fallow124713853fa_llow
flyblow1841903flyblow
gangplow1541603gangplow
glow85222523___glow
hallow124818323ha_llow
haymow1773683hay_mow
mallow114014743ma_llow
outglow1154863outglow
reglow10339403_reglow
sallow94315753sa_llow
sunglow1143943sunglow
tallow93714203ta_llow
wallow123913513wa_llow

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.406440125.6
2DLD Change Limit134027426.04622167.9
3Display Results42420.0162625.0
 (SQL Overall)178691426.46827626.9
 
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.