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

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

191 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
bowls10612143(None) 
bawls105719321bawls
boils75427191boils
bolls75531311bolls
bowels114315591bowels
bowl96827701bowl_
bows96242861bow_s
cowls106922211cowls
fowls115518891fowls
howls116219221howls
jowls156214521jowls
owls76022931_owls
yowls115715431yowls
awls75926092_awls
awols84713522awols
baals76122702baals
bails75933522bails
balls76236412balls
bals66354042b_als
bawds116115492bawds
bawl95326062bawl_
behowls1534442behowls
bells76432162bells
bels66142492b_els
bills75632862bills
birls74023162birls
blows105423832blow_s
boars75229602boars
boas66150832bo_as
boats75635152boats
bobs86340642bo_bs
bocks134526572bocks
bodes84935102bodes
bods76244712bo_ds
boffs134915502boffs
bogle85821682bogle
bogles95020832bogles
bogs75742752bo_gs
bogus85616472bogus
bohos105618252bohos
boil66335182boil_
bola66035562bo_la
bolas74733762bolas
bold75432812bo_ld
bolds85825282bolds
bole66448692bo_le
boles75448602boles
boll65634752bo_ll
bolo65535952bo_lo
bolos75531372bolos
bolt66254172bo_lt
bolts76232112bolts
bolus79125542bolus
bombs115818822bombs
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032bo_os
boots75837972boots
bops86037982bo_ps
borals86721912borals
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
bos57966812bo__s
bosks115218852bosks
boss65938342bo_ss
botas75328782botas
botels84815802botels
bots66453952bo_ts
botts75224862botts
boule74828042boule
boules84925972boules
bouts75131312bouts
bow87051902bow__
bowed114533422bowed
bowel105621202bowel
bower107328182bower
bowers115523702bowers
bowled125018132bowled
bowleg12369172bowleg
bowlegs13366812bowlegs
bowler114217312bowler
bowlers123715782bowlers
bowless123310312bowless
bowse105420632bowse
bowses115718862bowses
boxes145625072boxes
boyla102912362boyla
boylas113011722boylas
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
brawls115214332brawls
broils84114172broils
browns116415632browns
brows105425982brow_s
buhls105111802buhls
bulls75629572bulls
burls74228852burls
byrls105711232byrls
coals76129602coals
coils75030082coils
cols66553082co_ls
cools75632632cools
cowl97530812cowl_
cows97046642cow_s
dolls66126922dolls
dols56943052do_ls
dowels104813342dowels
downs94918572downs
dows85941052dow_s
foals85721692foals
foils85025812foils
fools86824202fools
fouls87221432fouls
fowl105723632fowl_
goals65521292goals
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
growls104711112growls
hols76946292ho_ls
howes114730262howes
howfs144814502howfs
howks155016852howks
howl107625692howl_
hows106345602how_s
jowl146120302jowl_
jowly186410902jowly
jows146632092jow_s
koels94613902koels
kohls12437802kohls
lolls512121732lolls
lowes85732462lowes
lowly114113332lowly
lows75843012low_s
mewls105813232mewls
moils76125742moils
molls75129782molls
mols65948572mo_ls
mools76027172mools
mows96340832mow_s
noels56418702noels
noils55024332noils
nows75738232now_s
nowts86915852nowts
obols73715862obols
oils46337972_oils
owes75137102_owes
owl66228972_owl_
owns76819582_owns
pawls105617662pawls
polls74627722polls
pols66044562po_ls
pools74427702pools
pows95537662pow_s
prowls115511082prowls
roils54826792roils
rolls55326232rolls
rotls55620162rotls
rowels94515452rowels
rows75941752row_s
scowls11549592scowls
soils55327982soils
sols45448162so_ls
souls55127362souls
sows75342492sow_s
toils54527492toils
tolls54728432tolls
tools55325242tools
towels94314642towels
towns86018882towns
tows78545552tow_s
vowels124410482vowels
vows106626942vow_s
wawls115416472wawls
wools84421462wools
wows104633492wow_s
yawls114613602yawls
yowes114926372yowes
yowl105820952yowl_
yows106433122yow_s

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001911.35639675.5
3Display Results1911910.0503820.0
 (SQL Overall)1786911911.499119206.8
 
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.