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 “fogbow” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

122 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
fogbow154478(None) 
fogbows1643851fogbows
fogdog1234222fogdog
follow124010352follow
longbow1343862longbow
oxbow1734442_oxbow
aglow94711973_aglow
bonbon10310073bonbon
booboo1039463booboo
borrow114310723borrow
boubou1038433boubou
bow87051903___bow
bowwow1334463bowwow
cogon89120903cog_on
combo114519433combo_
combos125316613combos
cowboy1637063cowboy
dogdom1186363dogdom
doggo84410703doggo_
downbow1653393downbow
elbow10117703_elbow
embow1297563_embow
faggot1139053faggot
fagot9323403fag_ot
fallow124713853fallow
farrow12309973farrow
fellow123712743fellow
flow105924923f__low
flyblow1841903flyblow
flyboy17113913flyboy
fob86748333fo_b__
fobbed144112613fobbed
fobs96034273fo_b_s
foetor939563foetor
fog76945563fog___
fogbound1542953fogbound
fogdogs1333263fogdogs
fogey125617873fog_ey
fogeys13509263fogeys
fogged125518373fogged
fogger114414783fogger
foggy136714543fog_gy
foghorn1445433foghorn
fogie96719003fog_ie
fogies104118063fogies
fogs87035003fog__s
fogy115923183fog__y
foible11410383foible
foison948933foison
folio83820883folio_
folios93915463folios
follows13409923follows
food86830573fo__od
fool75330593fo__ol
foot76248013fo__ot
footboy1544913footboy
forb97131333forb__
forbad122710503forbad
forbid123312433forbid
forbode13257963forbode
forbore12249673forbore
forbs105720803forb_s
forby135317673forb_y
forbye14427883forbye
fordo97218653fordo_
forgo94418333forgo_
forgot104318133forgot
formol112910333formol
frow106425053f__row
fugio9310923fugio_
fugios1037583fugios
furrow12427743furrow
fynbos1433283fynbos
glow85222523__glow
gobo76126903go_bo_
gobos86219383go_bos
gogo69722833gog_o_
gogos77516523gog_os
gombo105814043gombo_
gombos114311093gombos
grow86127303__grow
hobo97026083ho_bo_
hobos106321353ho_bos
hollow124212663hollow
hotbox1835703hotbox
kobo107422103ko_bo_
kobos115616893ko_bos
kotow12528713ko_tow
kowtow1643463kowtow
lobo67229863lo_bo_
lobos75921843lo_bos
logbook1454513logbook
logion76013723logion
logo57931763log_o_
logoi69715943log_oi
logon615922313log_on
logos67225333log_os
longbows1443883longbows
lowboy1435903lowboy
lowbrow1543273lowbrow
moonbow1443873moonbow
morrow113510093morrow
nohow1137293no_how
oboe66822943_o_boe
obol65220613_o_bol
oxbows1833713_oxbows
pegbox1844013pegbox
poboy121612223po_boy
pogrom1138593pogrom
potboy1397813potboy
powwow1342833powwow
reglow10339403reglow
regrow10309883regrow
robot7325973ro_bot
sorrow9339443sorrow
sunbow1145823sunbow
tomboy1358213tomboy
upbow1245613_upbow
upgrow1234273upgrow
wingbow1643773wingbow
yobbo1237873yobbo_
yobbos1335963yobbos

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161225.07622205.7
3Display Results1221220.0333697.0
 (SQL Overall)1786911225.48532578.1
 
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.