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

300 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
bices9502996(None) 
bice86235571bice_
bicep115413541bicep
biceps12447711biceps
bides85536781bides
bikes117529471bikes
biles75542141biles
bines76946791bines
bises75435621bises
bites75641171bites
bizes165923661bizes
dices86434241dices
fices106031161fices
ibices10398161ibices
ices66129641_ices
rices75536151rices
sices75637271sices
vices105725531vices
abides94719892abides
aces67645092_aces
aides65336612aides
amices105018012amices
apices104916262apices
babes95834112babes
baches135426942baches
backs135729622backs
baizes174315052baizes
bakes117035372bakes
bales76250082bales
banes74945582banes
bares75457132bares
bases75644352bases
bates75846342bates
becks135522012becks
bees65453382b_ees
beiges91014412beiges
benes75536232benes
bes56557432b__es
beses75830722beses
bias64738172bi_as
biases84618432biases
bibbs84911582bibbs
bibles104617642bibles
bibs84831002bi_bs
bicker144819172bicker
bickers154316552bickers
bide76041512bide_
bided95424972bided
bider85728382bider
biders94822802biders
bidet84935632bidet
bidets95215532bidets
bidis86721152bidis
bids75838462bi_ds
bier65531842bi_er
biers76225222biers
bifaces1448062bifaces
biffs134814412biffs
bigos85020012bigos
bigs76235032bi_gs
bike106532612bike_
biked125320032biked
biker116022562biker
bikers124517552bikers
bikies124515162bikies
bile66147192bile_
bilges94915632bilges
bilks115117892bilks
bills75632862bills
bimas95521742bimas
binds86627482binds
bine66650872bine_
biner75930692biner
biners85023632biners
binges93923122binges
bins66548262bi_ns
bints76130182bints
biogs85016112biogs
biomes103815252biomes
bios66335332bi_os
biped104718832biped
bipeds11458052bipeds
birches143412322birches
birds85421342birds
birks114920302birks
birles84920642birles
birls74023162birls
biros75325132biros
birrs74917102birrs
birse74517402birse
birses84717732birses
bis56860672bi__s
bise66437112bise_
bisks115416802bisks
bitches144117062bitches
bite66547012bite_
biter75030032biter
biters83925242biters
bits66148172bi_ts
bitts75022592bitts
bize155926302bize_
bizzes163910842bizzes
blites84721212blites
blues75127042blues
bocces123912022bocces
boches134618522boches
bocks134526572bocks
bodes84935102bodes
bodices12710592bodices
boites84322702boites
boles75448602boles
bones76446532bones
bores76448252bores
boxes145625072boxes
braces108427772braces
braes75735052braes
brees75632552brees
bribes105918532bribes
bricks144614622bricks
brides94423512brides
bries74942152bries
brines85028852brines
brises84927612brises
bucks134824292bucks
buses75936012buses
butes714535872butes
byes95230532b_yes
byres104421382byres
bytes105217492bytes
cines75239682cines
cires74932912cires
cites74435592cites
daces85030682daces
deices94119372deices
dice75841902dice_
diced95824682diced
dicer85426422dicer
dicers94720742dicers
dicey114819332dicey
dicks125824692dicks
dies55653532di_es
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
duces86327472duces
faces106439432faces
feces105625362feces
fice95737122fice_
fiches145219532fiches
ficoes114613462ficoes
ficus105015492ficus
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
fyces139813642fyces
gibes84422522gibes
gies55641432gi_es
gites65630182gites
gives95324872gives
hicks145322172hicks
hides95129432hides
hies74842842hi_es
hikes125426982hikes
hires86134342hires
hives116925512hives
ibises83610542ibises
ice56737252_ice_
iced78721892_iced
ichs96214712_ichs
ides57734242_ides
ires45639282_ires
jibes145520322jibes
jives154820812jives
juices1549422juices
kibes115521122kibes
kicks104420092kicks
kikes85122562kikes
kines95039142kines
kites95432552kites
laces76141762laces
lice66045072lice_
liches114724292liches
licks115325392licks
lies46454202li_es
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
luces75528432luces
maces97139962maces
micas96823052micas
mice87442242mice_
miches134320732miches
micks135525372micks
mics87435162mic_s
mikes115129892mikes
miles74645072miles
mimes95732022mimes
minces104420802minces
mines75651952mines
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
nice65534722nice_
nicer74618292nicer
nicest82315662nicest
niches114419142niches
nicks114920492nicks
nides65229142nides
nieces84112712nieces
nines55937342nines
nites55736342nites
nixes124519622nixes
paces96741112paces
picas94626522picas
pice84641102pice_
picks135226142picks
pics85633922pic_s
pieces104217272pieces
pies66949612pi_es
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
prices104524542prices
puces94924632puces
races74943242races
ribes75530172ribes
rice64942922rice_
riced85825542riced
ricer74726612ricer
ricers84120992ricers
riches115022082riches
ricks115126132ricks
rides66140822rides
riles55343642riles
rimes75634542rimes
ripes75435772ripes
rises55244042rises
rites54442552rites
rives85336002rives
saices84221802saices
sice65545602sice_
sicks115127622sicks
sics65234102sic_s
sides65838372sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
slices84022852slices
spices104326032spices
syces106416462syces
taces76237802taces
ticks115823292ticks
tics65729642tic_s
tides64830162tides
ties45248322ti_es
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
trices84826332trices
vibes104719952vibes
vice95732862vice_
viced115118182viced
vies75238632vi_es
vines85137642vines
vires84529682vires
vises84427772vises
voces105918052voces
voices114414012voices
wiches144418752wiches
wicks144619362wicks
wides94832832wides
wifes114522562wifes
wiles85437872wiles
winces114819112winces
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
yikes125117752yikes
yipes106017842yipes
zines145232652zines

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.296603685.8
2DLD Change Limit538003001.43637465.2
3Display Results3003000.0803750.0
 (SQL Overall)1786913001.81298615.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.