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

257 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
bizes16592366(None) 
baizes174315051baizes
bices95029961bices
bides85536771bides
bikes117529471bikes
biles75542141biles
bines76946791bines
bises75435621bises
bites75641171bites
bize155926281bize_
bizzes163910841bizzes
sizes146727761sizes
wizes174723341wizes
abides94719892abides
adzes155913802adzes
aides65336602aides
babes95834112babes
baizas173810822baizas
baize164717392baize_
bakes117035372bakes
bales76250082bales
banes74945582banes
bares75457132bares
bases75644352bases
bates75846342bates
bees65453382b_ees
beiges91014402beiges
benes75536232benes
bes56557432b__es
beses75830722beses
bezel165215172bezel
bezels173712282bezels
bias64738152bi_as
biases84618432biases
bibbs84911572bibbs
bibles104617642bibles
bibs84830972bi_bs
bice86235552bice_
bicep115413542bicep
biceps12447712biceps
bide76041472bide_
bided95424962bided
bider85728372bider
biders94822802biders
bidet84935622bidet
bidets95215532bidets
bidis86721142bidis
bids75838422bi_ds
bier65531822bi_er
biers76225222biers
biffs134814402biffs
bigos85020012bigos
bigs76235012bi_gs
bike106532592bike_
biked125320032biked
biker116022562biker
bikers124517552bikers
bikies124515162bikies
bile66147172bile_
bilges94915632bilges
bilks115117892bilks
bills75632862bills
bimas95521742bimas
binds86627472binds
bine66650852bine_
biner75930692biner
biners85023632biners
binges93923122binges
bins66548242bi_ns
bints76130182bints
biogs85016112biogs
biomes103815252biomes
bios66335312bi_os
biped104718832biped
bipeds11458052bipeds
birds85421332birds
birks114920302birks
birles84920642birles
birls74023162birls
biros75325132biros
birrs74917102birrs
birse74517402birse
birses84717732birses
bis56860652bi__s
bise66437092bise_
bisks115416802bisks
bite66546992bite_
biter75030032biter
biters83925232biters
bits66148152bi_ts
bitts75022592bitts
biz147939352biz__
bizones1837822bizones
blazes174817352blazes
blites84721212blites
blitzes18408702blitzes
blues75127042blues
bodes84935102bodes
boites84322702boites
boles75448602boles
bones76446532bones
bonzes175116102bonzes
boozes174916522boozes
bores76448252bores
boxes145625072boxes
bozos165216862bozos
braes75735052braes
braizes183112452braizes
brazes175522192brazes
brees75632552brees
bribes105918532bribes
brides94423512brides
bries74942152bries
brines85028852brines
brises84927612brises
buses75936012buses
butes714535872butes
buzzes165011172buzzes
byes95230532b_yes
byres104421382byres
bytes105217492bytes
cines75239682cines
cires74932912cires
cites74435582cites
cozes166033242cozes
dazes155024142dazes
dices86434242dices
dies55653522di_es
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dites66339152dites
ditzes163212422ditzes
dives95832402dives
dizen155214932dizen
dizens164911392dizens
dozes155226302dozes
fazes175527212fazes
fezes175220022fezes
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
fizzes174512552fizzes
frizes184015462frizes
fuzes175120222fuzes
gazes155425912gazes
gibes84422522gibes
gies55641422gi_es
gites65630182gites
gives95324872gives
hazes174928322hazes
hides95129422hides
hies74842832hi_es
hikes125426982hikes
hires86134342hires
hives116925512hives
ibices10398152ibices
ibises83610532ibises
ices66129642_ices
ides57734232_ides
ires45639282_ires
jibes145520322jibes
jives154820812jives
kibes115521112kibes
kikes85122552kikes
kines95039132kines
kites95432542kites
lazes145129572lazes
lies46454192li_es
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
maizes175115732maizes
mazes165632172mazes
mezes167719262mezes
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
mizen164815272mizen
mizens174610252mizens
nides65229132nides
nines55937342nines
nites55736342nites
nixes124519622nixes
oozes145418712oozes
phizes20389132phizes
pies66949602pi_es
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
prizes173819812prizes
razes145032702razes
ribes75530172ribes
rices75536152rices
rides66140812rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
ritzes154812942ritzes
rives85336002rives
seizes154317532seizes
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
size135630962size_
sized155519242sized
sizer145521812sizer
sizers155215812sizers
tides64830152tides
ties45248312ti_es
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
vibes104719952vibes
vices105725532vices
vies75238622vi_es
vines85137642vines
vires84529682vires
vises84427772vises
wides94832822wides
wifes114522562wifes
wiles85437872wiles
wines85546862wines
winzes184313052winzes
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizen175813862wizen
wizens186110262wizens
wizzes175110772wizzes
yikes125117752yikes
yipes106017842yipes
zines145232652zines

Search took 5 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.1701051123.5
2DLD Change Limit538002573.86013937.8
3Display Results2572570.1561647.4
 (SQL Overall)1786912574.18642687.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.