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

100 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
fogbows164385(None) 
fogbow1544781fogbow_
fogdogs1333262fogdogs
follows13409922follows
longbows1443882longbows
oxbows1833712_oxbows
bonbons1139333bonbons
booboos1138143booboos
borrows12349253borrows
boubous1138693boubous
bows96242863___bows
bowwows1454123bowwows
cogons96818113cog_ons
combos125316613combo_s
cowboys1735253cowboys
dogdoms1295423dogdoms
downbows1783693downbows
elbows1196713_elbows
embows1396823_embows
faggots1234863faggots
fagots1039963fag_ots
fallows133713973fallows
farrows13259783farrows
fellows134212433fellows
flows115822363f__lows
flyblows1942013flyblows
flyboys18112943flyboys
fobs96034273fo_b__s
foetors1039763foetors
fogbound1542953fogbound
fogdog1234223fogdo_g
fogeys13509263fog_eys
foggers124112013foggers
foghorn1445433foghorn
foghorns1544113foghorns
fogies104118063fog_ies
fogless1138193fogless
fogs87035003fog___s
foibles1238853foibles
foisons1047613foisons
folios93915463folio_s
folious103710733folious
follow124010353follow_
foods95924163fo__ods
fools86824203fo__ols
footboys1644333footboys
foots85528283fo__ots
forbids13268263forbids
forbode13257963forbode
forbodes14217103forbodes
forbore12249673forbore
forbs105720803forb__s
fordoes11311963fordoes
forgoes11311353forgoes
formols12299413formols
frows116623103f__rows
fugios1037583fugio_s
furrows13327793furrows
fynbos1433283fynbo_s
glows95518033__glows
goboes95914443go_boes
gobos86219383go_bo_s
gogos77516523gog_o_s
gombos114311093gombo_s
grows95523923__grows
hoboes114717443ho_boes
hobos106321353ho_bo_s
hollows134412333hollows
kobos115616893ko_bo_s
kotows13446523ko_tows
kowtows1742763kowtows
lobos75921843lo_bo_s
logbook1454513logbook
logbooks1544023logbooks
logions86211293logions
logons79818173log_ons
logos67225333log_o_s
longbow1343863longbow_
lowboys1534213lowboys
lowbrows1643483lowbrows
moonbows1543953moonbows
morrows12318723morrows
oboes75717713_o_boes
obols73715863_o_bols
oxbow1734443_oxbow_
poboys1397313po_boys
pogroms1237643pogroms
potboys1475273potboys
powwows1442853powwows
reglows11288843reglows
regrows11269153regrows
robots8313153ro_bots
sorrows10278403sorrows
sunbows1236023sunbows
tomboys1435713tomboys
upbows1384683_upbows
upgrows1334323upgrows
wingbows1743983wingbows
yobboes1445583yobboes
yobbos1335963yobbo_s

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.393454684.5
2DLD Change Limit1340271006.48320673.6
3Display Results1001000.0333030.3
 (SQL Overall)1786911006.90925863.5
 
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.