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

186 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
bowpot1341007(None) 
bowpots1446021bowpots
boot67759372bo__ot
bowknot1645772bowknot
bowshot1578252bowshot
bowwow1334462bowwow
cowpat13312032cowpat
cowpox2035002cowpox
ballot84624093ballot
bedpost1247243bedpost
begot84625953b_egot
beknot1239763beknot
besot76429713b_esot
bewept13410323bewept
bhoot104322093b_hoot
bigot84828323b_igot
bipod104410823b_ipod
blot65842323b__lot
blowjob2141753blowjob
blowout1248403blowout
boart78835933bo_art
boast75935703bo_ast
boat66360313bo__at
bobcat12411253bobcat
boffo136010373boffo_
boffos14568193boffos
bogart9617193bogart
bogwood1446413bogwood
boho96923323bo_ho_
bohos105618253bo_hos
bollox1548743bollox
bolo65535953bo_lo_
bolos75531373bo_los
bolson8410683bolson
bolt66254173bo__lt
bonbon10310073bonbon
bongo85720943bongo_
bongos95316653bongos
bonito8313433bonito
bonnet85524633bonnet
boo58163663bo__o_
boob85932583bo__ob
booboo1039463booboo
boocoo1039003boocoo
boohoo1148833boohoo
book106836333bo__ok
bookoo1248343bookoo
boom87435673bo__om
boon67142173bo__on
boor66130683bo__or
boos67955033bo__os
boost75132473bo_ost
booth105522013bo__oth
boots75837973bo__ots
booty106125913bo__oty
bop77549483bo_p__
bopped134413403bopped
bopper123813833bopper
bops86037983bo_p_s
boron76727143bo_ron
borrow114310723borrow
borsht11813503borsht
bort65960963bo__rt
borzoi1736623borzoi
bosket124919223bosket
bosom95516923bo_som
boson76019733bo_son
boston8513043boston
bot59680403b___ot
bott66548573bo__tt
bottom1048713bottom
boubou1038433boubou
boughpot1643503boughpot
bought125115633bought
bout66353293bo__ut
bouton8311533bouton
bow87051903bow___
bowed114533423bow_ed
bowel105621203bow_el
bowels114315593bowels
bower107328183bow_er
bowers115523703bowers
bowery146012113bowery
bowfin14338353bowfin
bowfront1644723bowfront
bowing124723063bowing
bowknots1743063bowknots
bowl96827703bow__l
bowled125018133bowled
bowleg12369173bowleg
bowler114217313bowler
bowls106121433bow_ls
bowman13129853bowman
bowmen1399853bowmen
bows96242863bow__s
bowse105420633bow_se
bowsed125715973bowsed
bowses115718863bowses
bowshots1645103bowshots
bowsprit1543653bowsprit
bowwows1454123bowwows
bowyer14368923bowyer
boxwood2045243boxwood
boycott1457313boycott
boyo96923843bo_yo_
boyos105418283bo_yos
bozo156821413bo_zo_
bozos165216863bo_zos
brownout1345683brownout
brulot8912213brulot
burbot10815653burbot
coapt96131533coap_t
complot13310683complot
compo115318573compo_
comport133616843comport
compos124818803compos
compost134515353compost
compote135616463compote
compt116328223comp_t
coopt95929853coop_t
coot67860383co__ot
coplot10518273coplot
copout10418783co_pout
coupon102810993coupon
cowboy1637063cowboy
cowpats1437713cowpats
cowpea1337643cowpea
cowpie133511513cowpie
cowplop1643363cowplop
cowpoke1835103cowpoke
cowrote12289673cowrote
coypou13268403coypou
depot85727923_depot
despot93413293despot
foot76248013fo__ot
forgot104318133forgot
fowlpox2241783fowlpox
gosport101010283gosport
hoopoe11911233hoopoe
hoopoo1198753hoopoo
hoot75752093ho__ot
hotspot1247453hotspot
howlet123518343howlet
inkpot1237813inkpot
joypop2063133joypop
kowtow1643463kowtow
loot46955823lo__ot
lowboy1435903lowboy
lowest93915593lowest
moot67653623mo__ot
moppet126915093moppet
motmot10311073motmot
nowt78833753now__t
oot311274693_o__ot
opt57545543_o_p_t
owlet83324463_owlet
pompom1436493pompom
pompon1238943pompon
poppet92717323poppet
pot58078433___pot
powwow1342833powwow
repot75132623_repot
respot83117633respot
robot7325973ro_bot
root45655923ro__ot
roupet84218343roupet
rowboat1267983rowboat
sexpot1539543sexpot
soot45761053so__ot
sopor74016493so_por
spot65540683__spot
swot75134653_sw_ot
teapot8416763teapot
tinpot8312513tinpot
toot45958883to__ot
topo66932403to_po_
topoi76018353to_poi
topos75726393to_pos
torot56139943to_rot
torpor839193torpor
tosspot966883tosspot
towboat1258303towboat
towmont1277633towmont
towpath1544043towpath
wot610467483__w_ot
youpon11366003youpon

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127161866.29617902.8
3Display Results1861860.0632952.4
 (SQL Overall)1786911866.48527554.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.