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

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

280 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
bifaces144806(None) 
biface1358101biface_
biases84618432bi_ases
bices95029962bi__ces
biffies152710852biffies
bipacks1745042bipacks
bonifaces1643732bonifaces
boraces113716852boraces
braces108427772b_races
defaces133213402defaces
effaces15277272effaces
enfaces122110912enfaces
faces106439432__faces
refaces123216742refaces
unifaces1346392unifaces
vivaces1536412vivaces
abidances1445593abidances
aces67645093___aces
airfares1146693airfares
anlaces92313733anlaces
baases85218013b_aases
babes95834113b__abes
baches135426943b__aches
backs135729623b__acks
baffies153612943baffies
baffles153710683baffles
bakes117035373b__akes
balances1279973balances
balases93815433balases
bales76250083b__ales
banes74945583b__anes
bares75457133b__ares
bases75644353b__ases
bates75846343b__ates
beaches144120653b_eaches
befalls12349123befalls
begazes1937963begazes
behaves15198523behaves
belaced124112153belaced
benames112814603benames
berakes134815773berakes
berates94126873berates
betakes134212523betakes
bewares12313373bewares
bialies93618413bialies
bialis83617163bi_alis
bialys11387913bi_alys
bias64738163bi_a__s
biased94012223bi_ased
biasses94911653biasses
bibles104617643bi_bles
bicarbs1336013bicarbs
bice86235563bi__ce_
bicep115413543bi__cep
biceps12447713bi__ceps
bicycles1743883bicycles
biddies113514493biddies
bides85536773bi__des
bifacial15105273bifacial
biffed15449883bif_fed
biffins15358533biffins
biffs134814413bif__fs
biflex1834953bif_lex
bifocal1445373bifocal
bifocals1543703bifocals
bigamies1337373bigamies
bigeyes1335653bigeyes
biggies113813523biggies
bigoses1039073bigoses
bikes117529473bi__kes
bikies124515163bi_kies
bilayer12347803bilayer
bilayers13296923bilayers
bilbies114712343bilbies
bilboes114410243bilboes
biles75542143bi__les
bilges94915633bi_lges
billies93923503billies
bimahs13508303bima_hs
bimas95521743bima__s
bimboes13498733bimboes
binaries10314183binaries
binate8419773binate_
bindles104016453bindles
bines76946793bi__nes
binges93923123bi_nges
bingoes104013983bingoes
binnacles13244583binnacles
binocles1236413binocles
binocs1039923binoc_s
biogases1136143biogases
biomes103815253bi_omes
bipack1636523bipac_k
biplanes1238573biplanes
birches143412323birches
birdies104016213birdies
biremes1138773biremes
birkies133712433birkies
birles84920643bi_rles
birses84717733bi_rses
bisects1137133bisects
bises75435623bi__ses
bisques18236893bisques
bistres94017213bistres
bitches144117063bitches
bites75641173bi__tes
bivalves1643383bivalves
bizarres1953793bizarres
bizes165923663bi__zes
bizones1837823bizones
bizzes163910843bi_zzes
blacks144914953b_lacks
blades95221253b_lades
blames105121863b_lames
blares85021633b_lares
blazes174817353b_lazes
bleaches153410673bleaches
bocces123912023b_occes
bodices12710593bodices
bolases93315003bolases
boldfaces1793223boldfaces
bonacis11310323bonacis
boniface1543863boniface_
borages103917163borages
boranes93720403boranes
borates94823013borates
boraxes163511633boraxes
bounces113813683bounces
brace95629273b_race_
braced115420603b_raced
bracer104620583b_racer
bracers114616703b_racers
braches144621223b_raches
brachs134415753b_rachs
bracts105617773b_racts
braes75735053b_ra_es
brakes124923123b_rakes
braves115524083b_raves
brazes175522193b_razes
breaches153714123breaches
brigades1236393brigades
brisances1345843brisances
broaches153211623broaches
bubales113513343bubales
bullaces12299433bullaces
butanes9312743butanes
bynames14256243bynames
catfaces1536963catfaces
cilices113814023cilices
cimices13279803cimices
daces85030683__daces
deface123113863deface_
defaced142910973defaced
defacer132810363defacer
defacers14237993defacers
defames132812253defames
dices86434243di__ces
didacts1186063didacts
dilates83220663dilates
dogfaces1554143dogfaces
edifices1454863edifices
efface14366673efface_
effaced16225573effaced
effacer15255413effacer
effacers16244233effacers
enface112510353enface_
enfaced13218913enfaced
enlaces92313393enlaces
face96140123__face_
faced117727653__faced
facer105525053__facer
facers115519443__facers
facet106038523__facet
facets116316653__facets
facies113921593__facies
facts107021893__facts
fades94932863__fades
faeces114713123__faeces
fakes126032483__fakes
falces115216003__falces
fames105735923__fames
fanes84639893__fanes
farces115223323__farces
fares85852873__fares
fasces114914543__fasces
fates85139233__fates
fauces114916153__fauces
faves115331423__faves
faxes155726653__faxes
fazes175527213__fazes
feces105625363__feces
fiacres1237253fi_acres
fiances12310673fiances
fices106031163__fices
fifes114822393fif__es
fifties132111083fifties
finales104016013finales
finances1338653finances
fixates1737393fixates
fyces139813643__fyces
giftees11306513giftees
glaces94218023_glaces
graces94523493_graces
grimaces1355383grimaces
hijacks2333533hijacks
hyraces1537913hyraces
ibices10398163_ibices
ices66129643_i__ces
images91411463_images
inanes62519803_inanes
infares10313023infares
inlaces92512903inlaces
irades74517393_irades
jiffies20327473jiffies
kinases113511123kinases
laces76141763__laces
lianes63819323li_anes
ligases82310713ligases
ligates82318383ligates
lilacs837483lilac_s
linacs8310813linac_s
linages8813173linages
lipases9209483lipases
maces97139963__maces
menaces112715523menaces
milages103114403milages
minces104420803mi_nces
miracles1238333miracles
mirages102213533mirages
misacts1139353misacts
nidates8311893nidates
nieces84112713ni_eces
nifties102612503nifties
offices1536243offices
orifices1346483orifices
outfaces132311393outfaces
paces96741113__paces
palaces114216453palaces
peaces106324083_peaces
piaffes15115053piaffes
pieces104217273pi_eces
pierces113411193pierces
piffles15368763piffles
pikakes1245823pikakes
pinnaces12268863pinnaces
pipages1289423pipages
piracies12312643piracies
pirates93020333pirates
places104323703_places
pomaces132712123pomaces
prefaces15311063prefaces
races74943243__races
reface113616353reface_
refaced133713573refaced
relaces93420883relaces
rices75536153ri__ces
riffles133911163riffles
rifles94217703rif_les
rivages1138873rivages
rubaces1139313rubaces
sices75637273si__ces
sifakas1443333sifakas
silages82514443silages
silanes72517163silanes
solaces93116133solaces
spaces104722633_spaces
surfaces1338673surfaces
taces76237803__taces
tenaces92814513tenaces
tierces93710453tierces
tirades8311723tirades
tisanes7311853tisanes
traces85329933_traces
uniface1236953uniface_
unlaces92513623unlaces
vices105725533vi__ces
visages1138693visages
vivace1436553vivace_
wifes114522563wif__es
winces114819113wi_nces

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272806.78319759.3
3Display Results2802800.1102545.5
 (SQL Overall)1786912807.28324535.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.