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

195 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
bitts7502259(None) 
batts76727561batts
bints76130181bints
bites75641171bites
bits66148161bi_ts
bitt65545811bitt_
bitty106119171bitty
botts75224861botts
britts84813441britts
butts75824251butts
mitts75523751mitts
airts55626342airts
aits46355532ai_ts
bahts105617802bahts
baits76630582baits
basts75936932basts
bates75846342bates
baths105922922baths
bats66962332b_ats
batt65053872batt_
battu75216612battu
batty105422242batty
beats76042242beats
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442b_ets
betta74916842betta
bettas84913922bettas
bhuts105812952bhuts
bias64738162bi_as
bibbs84911582bibbs
bibs84830992bi_bs
bices95029962bices
bides85536772bides
bidets95215532bidets
bidis86721142bidis
bids75838452bi_ds
biers76225222biers
biffs134814412biffs
bights124417962bights
bigos85020012bigos
bigots95015132bigots
bigs76235022bi_gs
bikes117529472bikes
biles75542142biles
bilks115117892bilks
bills75632862bills
bimas95521742bimas
binds86627472binds
bines76946792bines
binits85716672binits
bins66548252bi_ns
bint67355042bint_
biogs85016112biogs
bionts8612392bionts
bios66335322bi_os
biota74516822biota
biotas84313922biotas
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
birth105619872birth
births115713602births
bis56860662bi__s
bises75435622bises
bisks115416802bisks
bit57070902bi_t_
bitch125017762bitch
bite66547002bi_te
biter75030032biter
biters83925242biters
bitsy104511302bitsy
bitted94418482bitted
bitten84715122bitten
bitter84622672bitter
bitters94920362bitters
bizes165923662bizes
blats75132502blats
blets75324942blets
blites84721212blites
blots75626172blots
boats75635152boats
boites84322702boites
bolts76232112bolts
boots75837972boots
borts76735452borts
botas75328782botas
bots66453952b_ots
bott66548572bott_
bouts75131312bouts
brats75336012brats
briths115113862briths
brits76433082brits
britt75732232britt_
bruts75922952bruts
bunts75729802bunts
busts75227692busts
butes714535872butes
buts67247692b_uts
butt65143742butt_
butte74924292butte
buttes84822562buttes
butty104020112butty
bututs8409422bututs
bytes105217492bytes
cists76624532cists
cites74435592cites
diets66026642diets
dints67431312dints
dirts66824462dirts
ditas65923672ditas
dites66339152dites
dits56450522di_ts
ditto65315602ditto
dittos74111972dittos
ditty95019292ditty
fiats85324482fiats
fists85527542fists
fits76043462fi_ts
fritts94613192fritts
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gists66026192gists
gites65630182gites
gits55744592gi_ts
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132hi_ts
its35538832_i_ts
jilts124717412jilts
kilts95122182kilts
kists95822112kists
kites95432542kites
kiths125814972kiths
kits86441772ki_ts
kitty124614562kitty
lifts85719062lifts
lilts55822802lilts
lints57137192lints
lists56628692lists
litas54923772litas
lits46252492li_ts
matts76829182matts
milts75430712milts
mints76834042mints
mists76633902mists
mites75141802mites
mitis75425992mitis
mitt66145492mitt_
motts76527002motts
mutts75120252mutts
netts55320722netts
nites55736342nites
nits45741642ni_ts
nitty85418312nitty
obits74617552obi_ts
pints75936222pints
pitas77427672pitas
piths105817542piths
pits66348742pi_ts
pitta75018692pitta
pittas86014522pittas
putts75719272putts
rifts85718642rifts
riots54922012riots
rites54442552rites
setts55124322setts
sifts84918922sifts
silts55330822silts
sites56045432sites
sits45050202si_ts
situs55019232situs
tilts55325612tilts
tints56030922tints
titis56023812titis
tits46145042ti_ts
titty85316652titty
vitta85015172vitta
watts86923092watts
wilts85023502wilts
wists86728522wists
wites85536962wites
wits76044872wi_ts
witty114717012witty
yetts86715132yetts
zitis145815582zitis
zits136030292zi_ts

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.313570897.8
2DLD Change Limit538001951.40638264.6
3Display Results1951950.0464239.1
 (SQL Overall)1786911951.765101241.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.