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

241 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
boils7542719(None) 
bails75933521bails
boil66335181boil_
bolls75531311bolls
bowls106121431bowls
broils84114171broils
coils75030081coils
foils85025811foils
moils76125751moils
noils55024331noils
oils46337971_oils
roils54826791roils
soils55327981soils
toils54527491toils
aboil72217542aboil_
ails45654712_ails
anils56326722anils
arils58732202arils
axils127217502axils
baals76122702baals
bail65042802bail_
baits76630582baits
balls76236412balls
bals66354042b_als
basils85717472basils
bawls105719322bawls
bells76432162bells
bels66142492b_els
bezils1711310602bezils
bias64738162b_ias
bibs84830992b_ibs
bids75838432b_ids
bigs76235022b_igs
bile66147182b_ile
biles75542142b_iles
bilk105824422b_ilk
bilks115117892b_ilks
bill67239942b_ill
bills75632862bills
bins66548252b_ins
biogs85016112biogs
bios66335322b_ios
birls74023162birls
bis56860662b_i_s
bits66148162b_its
blips95615782blips
bliss75616912bliss
boars75229602boars
boas66150832bo_as
boats75635152boats
bobs86340652bo_bs
bocks134526572bocks
bodes84935102bodes
bodies94524142bodies
bodily12310992bodily
bods76244712bo_ds
boffs134915502boffs
bogies94724312bogies
bogle85821682bogle
bogles95020832bogles
bogs75742752bo_gs
bogus85616472bogus
bohos105618252bohos
boiled95020952boiled
boiler84319272boiler
boilers93417062boilers
boing84725552boing
boings96416872boings
boink115516332boink
boinks125211272boinks
boite74426322boite
boites84322702boites
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
bovids1287972bovids
bowels114315592bowels
bowl96827702bowl_
bows96242862bo_ws
boxes145625072boxes
boxily1877842boxily
boyla102912362boyla
boylas113011722boylas
boyos105418282boyos
boys96737332bo_ys
bozos165216862bozos
brails84621292brails
bries74942152bries
brigs85823222brigs
brill74819952brill
brills84916292brills
brims94721622brims
brins75533972brins
brios74725722brios
bris65539612bri_s
briss75824272briss
brits76433082brits
broil74918222broil_
buhls105111802buhls
build84413352build
builds9378492builds
built74325922built
bulls75629572bulls
burls74228852burls
byrls105711232byrls
ceils75019402ceils
coals76129602coals
coifs105718702coifs
coil66439652coil_
coins75834552coins
coirs75221052coirs
cols66553082co_ls
cools75632632cools
cowls106922212cowls
deils65722862deils
diols65521012diols
doily95321032doily
doits66223672doits
dolls66126922dolls
dols56943052do_ls
evils84114262evils
fails85631482fails
fils75838692_fils
foals85721692foals
foil76433912foil_
foins85523382foins
fools86824202fools
fouls87221432fouls
fowls115518892fowls
goals65521292goals
hails85231642hails
heils85222192heils
hols76946292ho_ls
howls116219222howls
jails125422942jails
joins125818412joins
jowls156214522jowls
kails95525212kails
koels94613902koels
kohls12437802kohls
kois85129402koi_s
loids66220702loids
loins56728422loins
lolls512121732lolls
mails76037782mails
mils66045332_mils
moil65534092moil_
molls75129782molls
mols65948572mo_ls
mools76027172mools
nails55730402nails
nils46132452_nils
noels56418702noels
noil46133242noil_
noily86120992noily
noirs55615462noirs
obias76116862obias
obis66226842obi_s
obits74617552obits
obols73715862obols
oil37452052_oil_
oily77932252_oily
owls76022932_owls
pails75833062pails
poilu72316002poilu
poilus82210572poilus
pois66539042poi_s
polis74731162polis
polls74627722polls
pols66044562po_ls
pools74427702pools
rails55937402rails
reboils94111722reboils
reoils64516872reoils
roil46235292roil_
roily86121112roily
rolls55326232rolls
rotls55620162rotls
sails55738102sails
soil46138832soil_
sols45448162so_ls
souls55127362souls
spoils84614532spoils
tails55634192tails
tils45739612_tils
toil46536282toil_
toile54626492toile
toiles63923512toiles
toits55327472toits
tolls54728432tolls
tools55325242tools
upboils1184702upboils
vails85825932vails
veils84918802veils
viols86118102viols
voids95414672voids
voila84813942voila
voile84719722voile
voiles94616442voiles
wails86631482wails
wools84421462wools
yowls115715432yowls
zorils153810882zorils

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 Filter178691538000.190940478.9
2DLD Change Limit538002415.7969282.3
3Display Results2412410.406593.6
 (SQL Overall)1786912416.39227955.4
 
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.